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.
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