[Terry Note] IMPDP error ORA-39083 Object type TYPE failed to create

Source: Internet
Author: User

When importing data using impdp today (converting schema in the same database ),
ORA-39083: Object type TYPE failed to create with error:
ORA-02304: invalid object identifier literal
The specific error SQL statement is CREATE TYPE "xx". "xxxxx" OID '1j35j43h1j5h2jk3hj52h3j45' AS OBJECT
This type cannot be created successfully because the OID is the same and the OID is the object id.


You can use the following parameter to view impdp help = y: transform
 
TRANSFORM
Metadata transform to apply to applicable objects.
Valid transform keywords: SEGMENT_ATTRIBUTES, storage oid, and PCTSPACE.
 
OID-If the value is specified as n, the assignment of the exported OID during
Creation of object tables and types is inhibited. Instead, a new OID is assigned.
This can be useful for cloning schemas, but does not affect referenced objects.
Default value is y.

This parameter defaults to Y. If it is changed to N, each object will be re-assigned with a new OID during import.

transformoid:n

In this way, it will not appear when impdp is used for import.
ORA-39083: Object type TYPE failed to create with error:
ORA-02304: invalid object identifier literal


Note: exp/imp does not support oid conversion and is also an advantage of using data pumps.

Related Article

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.