If you try to duplicate in the same database, one schema that contains TYPE objects, the following error might appear
ORA-39083: Object type TYPE failed to create
This is due the fact that the TYPE object has an associated object identifier (OID) that must be unique in database. By duplicating this TYPE, at import time this will have the same OID.
Prior to 10.2.0 this object must be created prior to import in destination schema nad the error regarding existence of object can be ignored
Starting with 10.2.0, there is the option to put TRANSFORM=OID:n in impdp command at import time
ORA-39083: Object type TYPE failed to create
This is due the fact that the TYPE object has an associated object identifier (OID) that must be unique in database. By duplicating this TYPE, at import time this will have the same OID.
Prior to 10.2.0 this object must be created prior to import in destination schema nad the error regarding existence of object can be ignored
Starting with 10.2.0, there is the option to put TRANSFORM=OID:n in impdp command at import time
No comments:
Post a Comment