Database Administration (MOSC)

MOSC Banner

ORA-02304: invalid object identifier literal

edited Sep 23, 2015 10:06AM in Database Administration (MOSC) 4 commentsAnswered

hi all im currently doing IMPDP on  10.2.0.5 database. It a large database and i can't afford to reimport back. Is this error can be ignore without and issue? or if it needs to be rectify whats steps need to be perform if i don't want to reimport back. Please help i need a solution for this as the schema is almost 1T.

Please help ASAP.

ORA-39083: Object type TYPE failed to create with error:
ORA-02304: invalid object identifier literal
Failing sql is:
CREATE TYPE "WMStest_DW"."STRING_AGG_TYPE"   OID '0AF355DCD9581984E0540003BAE51F61' as object
   (
      total varchar2(4000),

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

Instructions for posting

×

1. Select a discussion category from the picklist.


2. Enter a title that clearly identifies the subject of your question.


3. In the body, insert detailed information, including Oracle product and version.


Please abide by the Oracle Community guidelines and refrain from posting any customer or personally identifiable information (PI/CI).


Cloud / Fusion customers - Our Cloud community has moved! Please go to Cloud Customer Connect .


New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center