Oracle Database Import and Export, ORA-39083; ORA-00439 error Solution

Oracle Database Import and Export, ORA-39083; ORA-00439 error solution ORA-39083: Object type TABLE: "TEST ". "TEST_SS_NAME" failed to create with error: ORA-00439: feature not enabled: Deferred Segment Creation error resolution and resolution; error: No segment is assigned when the table is empty to save space, as a result, tables cannot be created in the new database. Www.2cto.com solution: view the deferred_segment_creation status in the source database; set the deferred_segment_creation status to false so that empty tables can be exported and imported in the future; view all empty tables under the current user; add or delete empty tables; re-export and import data; 1. view the deferred_segment_creation status of the source and target databases: [html] SQL> show parameter deferred_segment_creation NAME TYPE VALUE =---------------------------------------- deferred_segment_creation boolean FALSE 2. Set true to false; [html] SQL> alter system set deferred_segment_creation = false scope = both; [html] System altered. [html] view the status after setting [html] SQL> show parameter deferred_segment_creation NAME <span style = "white-space: pre "> </span> TYPE <span style =" white-space: pre "> </span> VALUE =----------- -------------------------------- www.2cto.com deferred_segment_creation <span style =" white-space: pre "> </span> boolean <span style =" white-space: pre "> </span> FALSE 3. view the empty table in the source database: select table_name from user_tables where NUM_ROWS = 0; 4. Edit the data of the empty table and restore it to the original null value in time; 5. re-import and export the data; expdp username/password @ oraclesid directory =/backup/export ledumpfile = test1_1.dmpimpdp username/password @ oraclesid directory =/backup/export ledumpfile = test1_1.dmp remap_schema = username: username