-
expdp
Hi,
When backing up database through expdp, would it also backup unused blocks? Or it only backed up the used ones?
Thanks
Claire
-
expdp isnt a backup tool - it takes a logical copy of the data in the database and doesnt touch block level
-
So how to estimate the size of expdp dump file?
-
There is no certain was to eastimate your size of the dump size to be .
It's completly depends upon the size of the segments excluding the frgmented blocks. Some of the case it may increase the size as same as the source segment.
So it is better to estimate as same size as the source segment.
-
Estimate_only
With datapump you can use the ESTIMATE_ONLY option which instructs Export to estimate the space that a job would consume, without actually performing the export operation.
"The person who says it cannot be done should not interrupt the person doing it." --Chinese Proverb
-
Wow...this is great. Thank you so much......
-
I tried it and worked like champ!
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|