Oracle导入导出expdp&impdp

su - oracle 进入数据库用户；

先创建directory ：test2_dir

创建：

create directory test2_dir as '/u01/app/oracle/admin/orcl/dpdump';

查询：

select * from dba_directories ;

删除：

drop directory test2_dir

再赋权：

GRANT ALL ON DIRECTORY test2_dir to public

导出语句：

expdp sys/sys directory=test2_dir dumpfile=0531.dmp full=y;

expdp "'sys/sys@kf as sysdba'" directory=TEST2_DIR dumpfile=0617.dmp full=y compression=all

按提示重新输入

username：sys as sysdba

password：sys

导出成功；

-------------------------------------------------------------------------------------------

导入数据库先创建directory ：test2_dir

创建：

create directory test2_dir as '/u01/app/oracle/admin/orcl/dpdump';

查询：

select * from dba_directories ;

删除：

drop directory test2_dir

再赋权：

GRANT ALL ON DIRECTORY test2_dir to public

把导出的文件0531.dmp拷贝至\Oracle\admin\orcl\dpdump目录下

cmd运行控制台进入到\Oracle\admin\orcl\dpdump目录下

执行导入语句：

impdp sys/sys directory=test2_dir dumpfile=0531.dmp full=y transform=segment_attributes:n;

按提示重新输入

username：sys as sysdba

password：orcl

impdp 'system/njzqcs@njzqcs as sysdba' directory=DATA_PUMP_DIR dumpfile=CCDB20180811FULL.dmp logfile=12.log full=y transform=segment_attributes:n