I want to export my database to multiple dmp files like dbname1.dmp ,dbname2.dmp etc.....Can somebody tell me the export option parameter to do so ??
I recently saw a note on Metalink, check it out.
yes you can do that.There is a new parameter called filesize .
filesize limits the size of each dmp file(ex-1024M,512M )
in file=c:\exp_1.dmp,d:\exp_2.dmp like that you have to mention
when the file size reaches the limit that is mentioned in the filesize parameter then it will skip to the next mentioned file ..
it is that simple...
In which version it works
It was there prior to 8.1.5 but the size of the file is operating system dependent.
For 32 bit OS it is 2G
For 64 bit OS it is unlimited.
This is from Oracle documentation
Export reaches the value you have specified for the maximum FILESIZE, Export stops writing to the current file, opens another export file with the next name
specified by the parameter FILE and continues until complete or the maximum value of FILESIZE is again reached. If you do not specify sufficient export filenames to complete the export, Export will prompt you to provide additional filenames.
Click Here to Expand Forum to Full Width