EXP/IMP
导出导入全库
SET/EXPORT NLS_LANG=AMERICAN_AMERICA.UTF8
EXP SYSTEM/LKFI FULL=Y FILE=D:\EXP\TESTSHF_N_FULL.DMP LOG=D:\LOG\TESTSHF_N_FULL.LOG
IMP SYSTEM/LKFI FULL=Y FILE=D:\EXP\TESTSHF_N_FULL.DMP LOG=D:\LOG\TESTSHF_N_FULL.LOG
导出导入指定schema
EXP SYSTEM/LKFI OWNER=SCOTT FILE=D:\EXP\TESTSHF_N_SCOTT.DMP LOG=D:\LOG\TESTSHF_N_SCOTT.LOG
将scott的schema导入至scott_n
IMP SYSTEM/LKFI FROMUSER=SCOTT TOUSER=SCOTT_N FILE=D:\EXP\TESTSHF_N_SCOTT.DMP LOG=D:\LOG\IMP_TESTSHF_N_SCOTT.LOG
导出schema中的数据结构,并且不导出权限约束和索引约束
EXP SYSTEM/LKFI OWNER=SCOTT INDEXES=N ROWS=N GRANTS=N FILE=D:\EXP\EXP_SCOTT_STR.DMP LOG=D:\LOG\EXP_SCOTT_STR.LOG
将导出的scott用户下的数据结构导入到scott_n的schema中
IMP SYSTEM/LKFI FROMUSER=SCOTT TOUSER=SCOTT_N ROWS=N
FILE=D:\EXP\EXP_SCOTT_STR.DMP LOG=D:\LOG\IMP_SCOTT_STR.LOG
导出导入SCOTT用户下的EMP和DEPT表结构
EXP SYSTEM/LKFI TABLES=SCOTT.EMP,SCOTT.DEPT ROWS=N FILE=D:\EXP\EXP_SCOTT_EMP_DEPT.DMP LOG=D:\LOG\EXP_SCOTT_EMP_DEPT.LOG
将表结构导入到SCOTT_N用户下
IMP SYSTEM/LKFI FROMUSER=SCOTT TOUSER=SCOTT_N FILE=D:\EXP\EXP_SCOTT_EMP_DEPT.DMP LOG=D:\LOG\IMP_SCOTT_EMP_DEPT.LOG
EXPDP/IMPDP
C:\>SET NLS_LANG=AMERICAN_AMEICA.UTF8
SQL> create directory expdp_dir as 'D:\EXPDP';
Directory created.
SQL> grant read,write on directory expdp_dir to scott;
Grant succeeded.
SQL> grant read,write on directory expdp_dir to scott_n;
Grant succeeded.
导出导入全库
EXPDP SYSTEM/LKFI DIRECTORY=EXPDP_DIR DUMPFILE=EXPDP_TESTSHF.DMP
LOGFILE=EXPDP_TESTSHF.LOG FULL=Y
IMPDP SYSTEM/LKFI DIRECTORY=EXPDP_DIR DUMPFILE=EXPDP_TESTSHF.DMP LOGFILE=EXPDP_TESTSHF.DMP
导出schema
EXPDP SYSTEM/LKFI DIRECTORY=EXPDP_DIR SCHEMAS=SCOTT DUMPFILE=TESTSHF_N_SCOTT.DMP LOGFILE=TESTSHF_N_SCOTT.LOG
将导出的schema导入到scott_n中
IMPDP SYSTEM/LKFI DIRECTORY=EXPDP_DIR SCHEMAS=SCOTT DUMPFILE=TESTS
HF_N_SCOTT.DMP LOGFILE=IMP_TESTSHF_N_SCOTT.LOG REMAP_SCHEMA=SCOTT:SCOTT_N REMAP_TABLESPACE=USERS:TESTSHF_N_SCOTT
导出导入表
EXPDP SYSTEM/LKFI DIRECTORY=EXPDP_DIR TABLES=SCOTT.EMP,SCOTT.DEPT DUMPFILE=EXPDP_SCOTT_EMP+DEPT.DMP LOGFILE=EXPDP_SCOTT_EMP+DEPT.LOG
IMPDP SYSTEM/LKFI DIRECTORY=EXPDP_DIR REMAP_SCHEMA=SCOTT:SCOTT_N DUMPFILE=EXPDP_SCOTT_EMP+DEPT.DMP LOGFILE=IMPDP_SCOTT_EMP+DEPT.LOG
只导出表结构
EXPDP SYSTEM/LKFI DIRECTORY=EXPDP_DIR DUMPFILE=EXPDP_SCOTT_METADATA.DMP LOGFILE=EXPDP_SCOTT_METADATA.LOG CONTENT=METADATA_ONLY TABLES=SCOTT.EMP,SCOTT.DEPT
导入表结构
IMPDP SYSTEM/LKFI DIRECTORY=EXPDP_DIR DUMPFILE=EXPDP_SCOTT_METADATA.DMP LOGFILE=IMPDP_SCOTT_METADATA.LOG CONTENT=METADATA_ONLYREMAP_SCHEMA=SCOTT:SCOTT_N
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/29320885/viewspace-1267761/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/29320885/viewspace-1267761/