Tablespace level Importing

SQL> select name from v$tablespace;

SQL> select name from v$datafile;

SQL> drop tablespace ssss including contents and datafiles;

SQL> create tablespace ssss

                datafile '/u02/app/oracle/ssss/ssss01.dbf'

                size 2m autoextend on;

SQL> alter user u1 default tablespace ssss;

SQL> conn u1/u1

u1> select * from tab;

 

oracle logical> imp file=ts.dmp full=y

                username : / as sysdba