Issue: ORACLE 11g exports a user's own table with the EXP command export and IMP imports 10g found empty table cannot be exported
Cause: 11g When you start to build a table, segment is not assigned by default to save space, and when the table inserts the first data, it is redistributed segment
Workaround 3 ways:
1: Insert a piece of data into the blank, and then delete it, allocate space (the empty table is relatively small).
2: Modify the system parameters of alter systems set DEFERRED_SEGMENT_CREATE=FALSE;
(segment will be assigned to the newly added table system), restart the database.
3: Allocating space to existing empty tables in bulk
Select ' ALTER TABLE ' | | table_name | | ' allocate extent; ' As SQL from all_tables where num_rows = 0 and owner=username;
Perform import and export work 1. Exp System/[email protected] owner=username1 file=expfile.dmp full=y 2. Imp ystem/[email protected] fromuser=username1 touser=username2 ignore=y file=expfile.dmp full=y
"ORACLE" 11g database table export and import 10g spatio-temporal table problems that cannot be exported