Table level Importing

oracle logical> ls

SQL> conn u1/u1

u1> select * from tab;

u1> drop table emp purge;

u1> drop table dept purge;

u1> select * from tab;

 

oracle logical> imp file=table.dmp fromuser=scott touser=u1

                username : / as sysdba

u1> select * from tab;

u1> drop table emp purge;

 

oracle logical> imp file=table.dmp tables=emp fromuser=scott touser=u1

                username : / as sysdba

u1> select * from tab;