IMP username/password@database_alias FILE=filename.dmp LOG=imp_log.txt

IMP HELP=Y

Anamika

SQL> create tablespace test_anamika
  2  datafile '/oradata2/DataFile/test_anamika.dbf' size 10M;

Tablespace created.

SQL> create user anamika identified by anamika default tablespace test_anamika;

User created.

SQL> grant dba to anamika;

Grant succeeded.

SQL> connect anamika/anamika;
Connected.
SQL> create table test ( a number);

Table created.
SQL> select table_name from dba_tables where tablespace_name='TEST_ANAMIKA';

TABLE_NAME
------------------------------
TEST

SQL> host exp anamika/anamika file=/backup/arju1.dbf tables=test;

Export: Release 10.2.0.1.0 - Production on Thu Aug 16 13:02:46 2007

Copyright (c) 1982, 2005, Oracle.  All rights reserved.


Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
With the Partitioning, OLAP and Data Mining options
Export done in US7ASCII character set and AL16UTF16 NCHAR character set
server uses WE8ISO8859P1 character set (possible charset conversion)

About to export specified tables via Conventional Path ...
. . exporting table                           TEST          0 rows exported
Export terminated successfully without warnings.

SQL> desc test;
 Name                                      Null?    Type
 ----------------------------------------- -------- ----------------------------
 A                                                  NUMBER

SQL> drop table test;

Table dropped.

SQL> connect / as sysdba
Connected.
SQL> drop user anamika cascade;

SQL> connect anamika/anamika
ERROR:
ORA-01017: invalid username/password; logon denied


SQL> select user_name from dba_users;
SP2-0640: Not connected
SQL> connect / as sysdba
Connected.
SQL> drop tablespace test_anamika including contents and datafiles;

Tablespace dropped.

SQL> create tablespace arju
  2  datafile '/oradata2/DataFile/arju01.dbf' size 10M;

Tablespace created.

SQL> create user arju_test identified by arju default tablespace arju;

User created.

SQL> grant dba to arju_test;

Grant succeeded.

SQL> host imp arju_test/arju file='/backup/arju1.dbf' full=y

Import: Release 10.2.0.1.0 - Production on Thu Aug 16 13:09:45 2007

Copyright (c) 1982, 2005, Oracle.  All rights reserved.


Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
With the Partitioning, OLAP and Data Mining options

Export file created by EXPORT:V10.02.01 via conventional path

Warning: the objects were exported by ANAMIKA, not by you

import done in US7ASCII character set and AL16UTF16 NCHAR character set
import server uses WE8ISO8859P1 character set (possible charset conversion)
. importing ANAMIKA's objects into ARJU_TEST
. importing ANAMIKA's objects into ARJU_TEST
. . importing table                         "TEST"          0 rows imported
Import terminated successfully without warnings.

SQL> connect arju_test/arju
Connected.
SQL> select * from tab;

TNAME                          TABTYPE  CLUSTERID
------------------------------ ------- ----------
TEST                           TABLE

SQL> desc test;
 Name                                      Null?    Type
 ----------------------------------------- -------- ----------------------------
 A                                                  NUMBER

SQL> select table_name, tablespace_name from dba_tables where owner='ARJU_TEST';

TABLE_NAME                     TABLESPACE_NAME
------------------------------ ------------------------------
TEST                           ARJU