Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- impdp system/*** DIRECTORY=expdp REMAP_SCHEMA=X:Y REMAP_TABLESPACE=X_TS:Y_TS DUMPFILE=X.dmp PARALLEL=2 LOGFILE=X_Y.dmp.imp.log INCLUDE=JAVA_CLASS
- Processing object type SCHEMA_EXPORT/JAVA_CLASS/JAVA_CLASS
- ORA-39083: Object type JAVA_CLASS failed to create with error:
- ORA-31625: Schema X is needed to import this object, but is unaccessible
- ORA-06512: at "SYS.DBMS_SYS_ERROR", line 86
- ORA-06512: at "SYS.KUPW$WORKER", line 9189
- ORA-01435: user does not exist
- Failing sql is:
- DECLARE STATUS NUMBER; BEGIN STATUS := DBMS_JAVA.START_IMPORT('path/to/function$1', 0,29,0,3,424,1); IF STATUS !=0 THEN IF STATUS > 0 THEN STATUS := -STATUS; E
- impdp system/*** DIRECTORY=expdp REMAP_SCHEMA=X:Y REMAP_TABLESPACE=X_TS:Y_TS DUMPFILE=X.dmp PARALLEL=2 LOGFILE=X_Y.dmp.imp.log
- ORA-39083: Object type TABLE:"Y"."RESULT_TABLE" failed to create with error:
- ORA-00904: "Y"."UTL"."SOME_FUNCTION": invalid identifier
- Failing sql is:
- ALTER TABLE "Y"."RESULT_TABLE" MODIFY ("COLUMN_A" NUMBER GENERATED ALWAYS AS ("Y"."UTL"."SOME_FUNCTION"("COLUMN_A",1,18)) VIRTUAL )
Add Comment
Please, Sign In to add comment