impdp is failing for table where CAST function is used in the column
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
0