oracle表导出为dump文件(在源Oracle上执行)
1.登录sysdba用户
sqlplus / as sysdba
2.创建Oracle目录
CREATE OR REPLACE DIRECTORY dump_dir AS '/folder_path';
3.对此目录给用户授权
GRANT READ,WRITE ON DIRECTORY dump_dir TO username;
4.退出sysdba用户
exit;
5.Oracle导出dump文件
按用户导出
expdp username/password@orcl schemas=username dumpfile=dump_file_name.dmp DIRECTORY=dump_dir;
按表名导出
expdp username/password@orcl TABLES=table_name_01,table_name_02,tabl