User level Importing

root> su - oracle

oracle> export ORACLE_SID=ssss

oracle> sqlplus / as sysdba

SQL> startup

root> su - oracle

oracle> eexport ORACLE_SID=ssss

oracle> ls

oracle> cd logical

 

SQL> conn scott/tiger

scott> select * from tab;

scott> conn / as sysdba

SQL> drop user scott cascade;

SQL> grant connect,resource to scott identified by tiger;

SQL> conn scott/tiger

scott> select * from tab;

 

oracle logical> imp file=user.dmp log=user.log fromuser=scott touser=scott ignore=y

                username : / as sysdba

scott> select * from tab;