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 Oracleappstechnical.com)
    LinkedIn profile - https://in.linkedin.com/in/sridevi-koduru-9b876a8b
    Please Contact for One to One Online Training on Oracle Apps Technical, Financials, SCM, SQL, PL/SQL, D2K at training@oracleappstechnical.com | +91 - 9581017828.

    ReplyDelete

Number of Visitors