Wednesday, January 2, 2013

Solution for Oracle 11g import export problem

If any table contain blank data export won't be proper in Oracle 11g.
Solution is Before Export we need to allocate extent to empty table.
Need to execute below query

select 'alter table '||table_name||' allocate extent;' from user_tables where segment_created = 'NO'

     above query will give  list of query to allocate extent to empty table like below

    alter table ELTRIX_TAG_MASTER allocate extent;
    alter table ELTRIX_TREND_CONFIG allocate extent;
    ...etc


   Then need to execute above list of queries , after that as usual  exp and imp commands will work without any issue.

No comments:

Post a Comment