dump_file 文件夹设定

--查看字符集
select userenv('language') from dual;
--SIMPLIFIED CHINESE_CHINA.ZHS16GBK

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

--创建目录
mkdir /backup/dump_file
chmod 775 /backup/dump_file

--创建dump_file路径
sqlplus "/as sysdba"
create directory dump_file as '/backup/dump_file';
grant read,write on directory dump_file to system;

--查看路径
select * from dba_directories;

--导出DMP文件
nohup expdp user/password  directory=dump_file dumpfile=yuqt.dmp schemas=yuqt compression=ALL &

expdp user/password  directory=dump_file dumpfile=table_name.dmp tables=talbe_name compression=ALL

--导入DMP文件
nohup impdp user/password directory=dump_file dumpfile=yuqt.dmp schemas=yuqt&

impdp user/password directory=dump_file dumpfile=table_name.dmp tables=talbe_name table_exists_action=replace