How to check dump file size in oracle

In this tutorial, we will show you How to check dump file size in Oracle. Sometimes, you need to export the entire database and may not know the exact space required for the dump file. Oracle provides the expdp command to perform this export.

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 ('huupv') AND segment_type NOT LIKE '%INDEX'
GROUP BY owner, segment_type
ORDER BY 1, 2;

Note:

• Replace [USER_NAME] with the specific username for which you want to get the dump size.
• For example, if [USER_NAME] is huupv, the query becomes:

SELECT owner, segment_type, SUM(bytes)/1024/1024/1024 GB
FROM dba_segments
WHERE owner IN ('huupv') AND segment_type NOT LIKE '%INDEX'
GROUP BY owner, segment_type
ORDER BY 1, 2;

Conclusion

Throughout the article, you can learn how to “check dump file size in Oracle” as described above. I hope you find this information helpful. Thank you for reading the DevopsRoles page!