Oracle EXPDP and IMPDP Common command options

First, EXPDP Export the database

1. Export by user

EXPDP Scott/Tiger@orcl   DIRECTORY=oracle_dmp  dumpfile=bak.dmp Schemas=Scott version=10.2.0.1.0;--If 10g imports 11g, plus version number

2. Export by database

EXPDP System/manager DIRECTORY=oracle_dmp dumpfile= full full =y;

3. Export by Table name

EXPDP Scott/Tiger@orcl TABLES=emp,dept DIRECTORY=oracle_dmp dumpfile= Bak.dmp;

4. Command optimization

?

Second, IMPDP Import Database

1. Create a user first

Create Temporarytablespace EAS_D_YXDB_STANDARD_TMEP tempfile'D:\APP\ADMINISTRATOR\ORADATA\ORCL\EAS_D_YXDB_STANDARD_TMEP. DBF'size 50m Autoextend on  Next50m maxsize 20480m extent management local;CreateTablespace Eas_d_yxdb_standard--Eas_d_eas32_standardLogging DataFile'D:\APP\ADMINISTRATOR\ORADATA\ORCL\EAS_D_YXDB_STANDARD. DBF'size 50m Autoextend on  Next50m maxsize 20480m extent management local; Create UserYangxiang identified byabc123defaulttablespace Eas_d_yxdb_standardTemporarytablespace EAS_D_YXDB_STANDARD_TMEP; GrantConnect,resource,dba toYangxiang;

2. Execute the Import command

IMPDP Yangxiang/abc123@orcl Directory=oracle_dmp dumpfile=eas3220150805.dmp Remap_schema=Eas32:yangxiang remap_tablespace='(eas_d_eas32_index:sx,eas_d_eas32 _STANDARD:SX,EAS_D_YXDB_STANDARD:SX,USERS:SX)'

Iii. use of exp and IMP

EXPSYSTEM/MANAGER BUFFER=64000 FILE=C + Full. CM7 Full=Y--fully exportedEXPSONIC/SONIC BUFFER=64000 FILE=C:\SONIC. DMP OWNER=SONIC--Export a userEXPSONIC/SONIC BUFFER=64000 FILE=C:\SONIC. DMP OWNER=SONIC TABLES=(SONIC)--Table ExportIMP SYSTEM/MANAGER BUFFER=64000 FILE=C + Full. CM7 Full=Y--Full ImportIMP SONIC/SONIC BUFFER=64000 FILE=C:\SONIC. DMP Fromuser=SONIC Touser=SONIC--Import between UsersIMP SONIC/SONIC BUFFER=64000 FILE=C:\SONIC. DMP OWNER=SONIC TABLES=(SONIC)--Table Import

Oracle EXPDP and IMPDP Common command options