BUFFER=200000 RECORDLENGTH=64000 FILE=Ora81Export1.dmp, Ora81Export2.dmp, Ora81Export3.dmp, Ora81Export4.dmp FILESIZE=20k LOG=Export.log FULL=y COMPRESS=yI am practicing on a very small database that produces a 2.6 K export file and don't have the means to create anything significantly bigger. I need to force the export to create multiple .dmp files to ensure I'm not caught out by the 2 GB limit. What do you suggest?
Dig Deeper on Oracle database backup and recovery
Related Q&A from Brian Peasland
Oracle expert Brian Peasland answers one reader's question about common pitfalls when connecting Oracle to outside programs. Continue Reading
One reader asks expert Brian Peasland a question about datafile sizes with the Oracle RMAN duplicate 10g command. Continue Reading
Managing parent table-child table relations in Oracle SQL environments is key to efficient programming. Continue Reading