How to split and export multiple dumpfiles in Oracle SQL Query :
expdp system/password@DB_NAME directory=data_pump_dir dumpfile=DUMP1_0%u.dmp ,DUMP2_1%u.dmp, DUMP3_2%u.dmp logfile=SPLITTED_DUMPFILES.log schemas=Schema_name FILESIZE=1024M
Note : You may decide the Filesize parameter of the dumpfile with reference to the size of the dump.
expdp system/password@DB_NAME directory=data_pump_dir dumpfile=DUMP1_0%u.dmp ,DUMP2_1%u.dmp, DUMP3_2%u.dmp logfile=SPLITTED_DUMPFILES.log schemas=Schema_name FILESIZE=1024M
Note : You may decide the Filesize parameter of the dumpfile with reference to the size of the dump.
No comments:
Post a Comment