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:-)
4 comments:
supra sneakers
oakley sunglasses
ugg boots
ferragamo outlet
ugg boots
ralph lauren outlet
mlb jerseys
michael kors outlet
michael kors handbags
ed hardy
jimmy choo shoes
longchamp handbags
adidas ultra
vans outlet
lebron 15 shoes
coach outlet
nike polo
michael kors outlet
ferragamo belt
michael kors outlet online
vapormax
longchamp handbags
yeezy shoes
canada goose jacket
jordan shoes
curry 5
adidas tubular shadow
chrome hearts online store
retro jordans
hermes
n4i76x6s00 w0x97u0u86 m9m56u8y14 l4c33c8y38 q3n75a8s30 z4o82w5n22
Post a Comment