Logical Incremental Backup : Importing

SQL> drop user scott cascade;

 

oracle logical> imp file=thursday.dmp log=thursday.log inctype=system ignore=y full=y

                username : / as sysdba

SQL> conn scott/tiger

 

oracle logical> imp file=sunday.dmp log=sunday.log inctype=restore ignore=y full=y

                username : / as sysdba

 

root> su - oracle

oracle> export ORACLE_SID=venu

 

oracle logical> imp file=wedday.dmp log=wedday.log inctype=restore ignore=y full=y

                username : / as sysdba

 

scott> select * from tab;

 

oracle logical> imp file=thursday.dmp log=thursday.log inctype=restore ignore=y full=y

                username : / as sysdba

 

scott> select * from tab;