I have an Oracle 11gr2 database running on Enterprise Linux 6.6 server.
I use the following command to split the expdp dump file to 10G size chunks:
expdp userid=/ DIRECTORY=dmpdir dumpfile=dump%u.dmp filesize=10G schemas=user1
this creates 4 files that I should move to another server (rsync then rm).
Can I move a file as soon as the expdp starts creating the following one? and how should I do that? I have idea like while (next_file not exists) wait.
Thank you.
Best Answer
It is not advisable to move files before the export job is finished. The reason is that when exporting, the utility "builds and maintains the master table for the duration of the job. At the end of an export job, the content of the master table is written to a file in the dump file set." (see Oracle's documentation at the following address: https://docs.oracle.com/database/121/SUTIL/GUID-6BDC1CC8-8596-402D-B016-602985B97AB6.htm#SUTIL814) If you move a dump file before the job is done, you risk corrupting that process and making the job fail.
Is there a reason you need to move the files before the data pump job is finished? If not, simply wait for the job to complete. While being able to move files as soon as they are not in use would be very useful for large export/import jobs, you will save yourself a lot of time by letting the export finish before manipulating the dump files.