expdp

 

一、创建目录对象

conn system/password as sysdba;

 

CREATE DIRECTORY dump_dir AS 'E:/databackup/normal';

GRANT READ,WRITE ON DIRECTORY dump_dir TO yd;

 

--check

SELECT * FROM dba_directories;

 

二、导出

 

（1）所有

expdp yd/password DIRECTORY=dump_dir DUMPFILE=schema.dmp SCHEMAS=yd

（2）结构

expdp yd/password DIRECTORY=dump_dir DUMPFILE=schema.dmp SCHEMAS=yd content=METADATA_ONLY

 

 

 

三、导入

impdp yd/password directory=dump_dir  DUMPFILE=schema.dmp SCHEMAS=yd