Getting error ORA-39082 while perfoming the import
ORA-39082: Object type FUNCTION:"HARVEY"."MY_DETAILS" created with compilation warnings
ORA-39082: Object type FUNCTION:"HARVEY"."MY_DETAILS" created with compilation warnings
ORA-39082: Object type VIEW:"HARVEY"."V_MY_DETAILS" created with compilation warnings
I was trying to import the schema twice and getting the error second time as second time I was importing contents to new schema and tablespace. I was using remap_schema and remap_tablespace. It turned out that it was a coding issue. Because the function had a fully qualified object name and in second import it was referring to the previous object and resulting in "PLS-00364: loop index variable 'string' use is invalid".
The fix was after import change the function and modify to point to new object and view was dependent on it and the compiling it to fix it.
ORA-39082: Object type FUNCTION:"HARVEY"."MY_DETAILS" created with compilation warnings
ORA-39082: Object type FUNCTION:"HARVEY"."MY_DETAILS" created with compilation warnings
ORA-39082: Object type VIEW:"HARVEY"."V_MY_DETAILS" created with compilation warnings
I was trying to import the schema twice and getting the error second time as second time I was importing contents to new schema and tablespace. I was using remap_schema and remap_tablespace. It turned out that it was a coding issue. Because the function had a fully qualified object name and in second import it was referring to the previous object and resulting in "PLS-00364: loop index variable 'string' use is invalid".
The fix was after import change the function and modify to point to new object and view was dependent on it and the compiling it to fix it.
No comments:
Post a Comment