Oracle data pump export not including 0 row tables

Oracle 11gr2 Enterprise data pump export does not include 0 row tables

1
C:\> expdp user/secret@SID DUMPFILE=out.dmp SCHEMAS=user LOG=out.txt

To correct, extend 0 row tables:

1
SELECT 'ALTER TABLE ' || TABLE_NAME || '  allocate extent;' FROM USER_TABLES where NUM_ROWS=0;

Leave a Reply