Database Utilities (MOSC)

MOSC Banner

impdp is failing for table where CAST function is used in the column

edited Aug 29, 2013 10:43AM in Database Utilities (MOSC) 5 commentsAnswered
Hello Experts,

 impdp is failing for table where CAST function is used in the column

ORA-39083: Object type TABLE:"schema_name"."table_name" failed to create with error:

ORA-00904: "schema_name"."ISACTIVE": invalid identifier

Column ACTIVE has this setup in the table.

ACTIVE  NUMBER(1) GENERATED ALWAYS AS (CAST("schema_name"."ISACTIVE"("EFFECTIVE_DT","EXPIRATION_DT","STATUS") AS NUMERIC(1))),


TIA

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

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center