When exporting with exp, ORACLE 11G found that empty tables (no data or unused tables) could not be exported. Check the data, said that Oracle 11G has a new feature, when the table has no data, do not allocate segment to save space, so these tables are not exported. Using the following SQL query, find the table that cannot be exported, the Segment_created field value is ' NO '. Select segment_created,table_name from user_tables where segment_created = ' NO '; Workaround: Set the Deferred_segment_creation parameter. The parameter value is true by default, and segment is assigned when false, whether it is an empty table or a non-empty table. You can disable this feature by modifying the deferred_segment_creation to False. The modification takes effect only for tables that are created later, and is not affected for tables that already exist. alter system set DEFERRED_SEGMENT_CREATION=FALSE; To export a table that already existed before, SQL execution can be generated from the following statement: Select ' ALTER TABLE ' | | table_name | | ' Allocate extent; ' As Sqlstr from User_tables where segment_created= ' NO ';
Oracle11g new attribute causes an empty table to not export problems
