How to make a database full export.
expdp user/password FULL=y DIRECTORY=data_pump_dir DUMPFILE=full%U.dmp FILESIZE=30G LOGFILE=myfullexp.log
This will generate full01.dmp, full02.dmp, full03.dmp files and so on.
data_pump_dir= This can be obtained and modified from dba_directories tables.
FILESIZE=Is the size for each dump file. This is useful for big files.
expdp user/password FULL=y DIRECTORY=data_pump_dir DUMPFILE=full%U.dmp FILESIZE=30G LOGFILE=myfullexp.log
This will generate full01.dmp, full02.dmp, full03.dmp files and so on.
data_pump_dir= This can be obtained and modified from dba_directories tables.
FILESIZE=Is the size for each dump file. This is useful for big files.
Comments