Wednesday, September 21, 2011

FILESIZE parameter in Datapump


FILESIZE:

Specifies the maximum size of each dump file. If the size is reached for any member of the dump file set, that file is closed and an attempt is made to create a new file, if the file specification contains a substitution variable.( such as %U.dmp)

Example 1:

expdp system/sys@delhi SCHEMAS=scott DUMPFILE = demo%U.dmp  FILESIZE=50k

The above command will create each dumpfile of size 50k.

Example 2:

The following shows an example in which the size of the dump file is set to 3 megabytes:

 expdp hr/hr DIRECTORY=dpump_dir1 DUMPFILE=hr_3m.dmp FILESIZE=3M

If three megabytes had not been sufficient to hold all the exported data, then the following error would have been displayed and the job would have stopped:

ORA-39095: Dump file space has been exhausted: Unable to allocate 217088 bytes

Enjoy:-)