Thursday 30 April 2015

Oracle 11g: expdp not including empty tables

To include empty tables in the dump file:

alter system set deferred_segment_creation=false scope=both;

Then alter table xx allocate extent;

No comments:

Post a Comment

Number of Visitors