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

ORA-39083: ObjecttypeTABLE: TEST. TEST_SS_NAMEfailedtocreatewitherror: ORA-00439: featurenotenabled: DeferredSegmentCreation error parsing and solution; error: when the table is

ORA-39083: ObjecttypeTABLE: TEST. TEST_SS_NAMEfailedtocreatewitherror: ORA-00439: featurenotenabled: DeferredSegmentCreation error parsing and solution; error: when the table is

ORA-39083: Object type TABLE: "TEST". "TEST_SS_NAME" failed to create with error:

ORA-00439: feature not enabled: Deferred Segment Creation

Error parsing and solution;

Error: when the table is empty, the U.S. space is not allocated with segment to save space. As a result, the table cannot be created in the new database.

Solution:

View the status of deferred_segment_creation in the source database;

Set the deferred_segment_creation status to false so that the empty table can be exported and imported in the future;

View All empty tables of 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]

2. Set true to false;

[Html]

[Html]

System altered.

[Html]

View the status after setting

[Html]

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 data;

Expdpusername/password @ oraclesid directory =/backup/export ledumpfile = test1_1.dmp

Impdpusername/password @ oraclesid directory =/backup/export ledumpfile = test1_1.dmp remap_schema = username: username

This article is from the "lonely city, rain and Sorrow" blog, Hong Kong virtual host, Hong Kong server, please be sure to keep this source