Oracle Data Pump Import and export case oracle database Import and Export tool, you can use Exp/imp, but this is the older tool. This paper mainly introduces the use of data pump EXPDP/IMPDP tools. Establishing a data pump catalog using a data pump requires first building directorycreate directory Dump_scott as '/home/oracle/dump/scott ' to view the established directory select * from Dba_ Directories empowering Grant Read,write on directory Dump_scott toscott export Case 1, export by table EXPDP Scott/tiger Directory=dump_ SCOTTDUMPFILE=TAB.DMP logfile=scott.log tables=dept,emp Export Case 2, export by user EXPDP Scott/tiger Directory=dump_ Scottdumpfile=dumpscott.dmp schemas=scott Export Case 3, full library export, and parallel export EXPDP Scott/tiger directory=dump_scottdumpfile= Full.dmp parallel=4 full=y Import Case 1, import by table, from Scott to SCOTT2IMPDP Scott2/tiger directory=dump_scottdumpfile=tab.dmp Tables=scott.dept,scott.emp remap_schema=scott:scott2 Import Case 2, import by user, from Scott to SCOTT2IMPDP Scott/tiger directory= Dump_scottdumpfile=schema.dmp remap_schema=scott:scott2 Import case 3, full library import IMPDP Scott/tiger Directory=dump_ Scottdumpfile=full.dmp full=y Import Case 4, user copy without floor file, need to establish DB LINKIMPDP Scott/tiger Directory=dump_scott network_link= Remote_link REMAP_SCHEMA=SCOTT:SCOTT2
Oracle Data Pump