Oracle 11G 11.2.0.1.0 using exp cannot export empty tables solution 11G (11.2.0.1.0) has a bug, when the table does not have data, no segment is assigned solution: www.2cto.com 1, insert a row, then rollback generates the segment. This method inserts data into an empty table and then deletes it, resulting in a segment. An empty table can be exported. 2. set the deferred_segment_creation parameter SQL> show parameter deferred_segment_creation name type value =----------- includeferred_segment_creation boolean true SQL> alter system set limit = false; after the change, it only takes effect for subsequent, and the oracle service needs to be restarted to take effect. 3. Manually allocate space to empty tables [SQL] www.2cto.com DECLARE CURSOR EMPTY_TABLES IS SELECT TABLE_NAME FROM USER_TABLES WHERE NUM_ROWS = 0; begin for tab in EMPTY_TABLES loop execute immediate 'alter table' | TAB. TABLE_NAME | 'allocate extent'; end loop; END;/11g (11.2.0.2.0) this bug seems to have been fixed. We recommend that you use the expdb command to export
Author scorpio3k