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;

1 comment:

  1. Regards
    Sridevi Koduru (Senior Oracle Apps Trainer
    LinkedIn profile -
    Please Contact for One to One Online Training on Oracle Apps Technical, Financials, SCM, SQL, PL/SQL, D2K at | +91 - 9581017828.


Number of Visitors