Oracle Database versions are 11.2.0.1.0 and the operating system is WIN2008 (64-bit). When importing data from server A to server B using impdp, an error is prompted:
Features not enabled for the ORA-00439: DEFERRED_SEGMENT_CREATION.
1. Check whether the DEFERRED_SEGMENT_CREATION parameter settings are the same
In database A query, the parameter is set to FALSE, and database B is set to TRUE.
Change Database B settings to FALSE and re-import. The same error is returned.
2. view the database version
One is the standard edition and the other is the Enterprise Edition.
DEFERRED_SEGMENT_CREATION is in the Standard Edition and cannot be changed.
3. Unsupported functions. data must be imported.
Check the online materials and finally find a solution:
When doing expdp, bring the parameter version = 10.2.0
Similarly, the impdp parameter version = 10.2.0 is also included.
PS:
After performing the preceding operations, the data can be imported. However, an error occurred while creating the index:
ORA-14102: only one LOGGING or NOLOGGING clause may be specified;
This is a bug in 11.2.0.1 and requires patching on the source Library:
P8795792_112010_Generic
Then re-expdp and import.