How to check dump file size in oracle

In this tutorial, How to check dump file size in Oracle? Sometimes you have to export all the databases and you won’t know exactly how much space for dump file? Oracle with exports is the expdp command.

Check dump file size in Oracle

The query calculates how much dump file table data each schema on your databases.

select owner, segment_type, sum(bytes)/1024/1024/1024 GB
from dba_segments
where owner in ('[USER_NAME]') and segment_type not like '%INDEX'
group by owner, segment_type order by 1,2 ;

Note:

  • [USER_NAME] assigns the username to get the dump
  • For example, [USER_NAME] is huupv

Conclusion

Thought the article, You can “check dump file size in Oracle” as above. I hope will this your helpful.

About HuuPV

My name is Huu. I love technology and especially Devops Skill such as Docker, vagrant, git so forth. I likes open-sources. so I created DevopsRoles.com site to share the knowledge that I have learned. My Job: IT system administrator. Hobbies: summoners war game, gossip.
View all posts by HuuPV →

Leave a Reply

Your email address will not be published. Required fields are marked *

Comment moderation is enabled. Your comment may take some time to appear.

This site uses Akismet to reduce spam. Learn how your comment data is processed.