Oracle export full database

sysdba登入sqlplus

sqlplus / as sysdba

在系統建立資料夾，如c:\export_db

在sqlplus運行

create directory [directory_name] as [directory path just create];

如：

create directory full_export as 'c:\export';

授權給用戶

grant read,write on directory [directory_name] to [user];
grant exp_full_database to [user];
grant imp_full_database to [user];

如：

grant read,write on directory full_export to user1;
grant exp_full_database to user1;
grant imp_full_database to user1;

退出sqlplus 運行expdp命令

格式：

expdp directory=[directory_name] dumpfile=[dump_file_name] logfile=[log_file_name] FULL=y

如：

expdp directory=full_export dumpfile=full_export.dmp logfile=full_export.log FULL=y