I'm exporting one specific table for a schema which I thought was a relatively small 5.4 GB
SQL> select bytes/1024/1024 MB from user_segments where segment_name='TABLENAME'; MB ---------- 5376
However, EXPDP estimates the export size to be over 8 times that size at 46 GB:
Connected to: Oracle Database 12c Enterprise Edition Release 18.104.22.168.0 - 64bit Production With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options Starting "SCHEMA"."SYS_EXPORT_TABLE_01": SCHEMA/********@DATABASE dumpfile=TABLENAME_20211028.dmp tables=TABLENAME Estimate in progress using BLOCKS method... Processing object type TABLE_EXPORT/TABLE/TABLE_DATA Total estimation using BLOCKS method: 45.87 GB
Why is the estimate so much larger than the "table size"?