Hello all,
I am a junior DBA in a small-scale startup and was recently given a mock task to migrate 650 GB schema with some parameters but I guess that is not working as expected. Below is the par file kindly let me know what should be added to get the desired output.
EXPDP_FULL_SCHEMA_TESTER.par
expdp \'/ AS SYSDBA\' SCHEMAS=TESTER DIRECT=Y DATA_PUMP=DIRECT PARALLEL=5 LOGTIME=ALL DIRECTORY=DUMPS VERSION=LATEST DUMPFILE=EXPDP_FULL_SCHEMA_TESTER_%U.dmp LOGFILE=EXPDP_FULL_SCHEMA_TESTER.log METRICS=Y JOB_NAME=EXPDP_FULL_SCHEMA_TESTER FILESIZE=100G
nohup expdp parfile=/testerdb/backups/dumps/EXPDP_FULL_SCHEMA_TESTER.par &
I expect 5 files to be created but only 1 file with 100GB is created and the next file is created only when the previous file has reached 100GB. My understanding was that the parallel parameter allows the creation of multiple files from the start, but this puzzles me. Kindly guide me.
Thanks in advance !!!