Recently I did a full export from an Oracle 10g database using a regular oracle account(not sys or system), and got the following errors:
...
. about to export SYSTEM's tables via Conventional Path ...
. . exporting table DEF$_AQCALL
EXP-00008: ORACLE error 6550 encountered
ORA-06550: line 1, column 18:
PLS-00201: identifier 'SYS.DBMS_DEFER_IMPORT_INTERNAL' must be declared
ORA-06550: line 1, column 7:
PL/SQL: Statement ignored
ORA-06512: at "SYS.DBMS_SYS_SQL", line 1204
ORA-06512: at "SYS.DBMS_SQL", line 323
ORA-06512: at "SYS.DBMS_EXPORT_EXTENSION", line 97
ORA-06512: at "SYS.DBMS_EXPORT_EXTENSION", line 126
ORA-06512: at line 1
. . exporting table DEF$_AQERROR
...
. . exporting table DEF$_ERROR
EXP-00008: ORACLE error 6510 encountered
ORA-06510: PL/SQL: unhandled user-defined exception
ORA-06512: at "SYS.DBMS_EXPORT_EXTENSION", line 50
ORA-06512: at "SYS.DBMS_EXPORT_EXTENSION", line 126
ORA-06512: at line 1
. . exporting table DEF$_LOB 0 rows exported
...
I have found that we need to grant some sys procedures to this user for getting rid of these errors.
So I logged in as sys and executed the following commands:
GRANT EXECUTE ON SYS.DBMS_DEFER_IMPORT_INTERNAL TO
GRANT EXECUTE ON SYS.DBMS_EXPORT_EXTENSION TO
And it really helped me to fix it.
Thanks,
Sergey.
6 comments:
Wow - works like a miracle.
Really good solution.
Thanks.
WOW .... that really worked
i was facing the same problem for couple of weeks and even Oracle support was not giving a solution.
but this trick really works .... thanks for sharing this
Thanks sergio, U.B.D.Man
Hi Guys,
Unfartunately i am using sys user to export the database eventhough i am getting the same error.
Please advise what could be the reason.
Regards,
Salai
Thanks a lot. This works and it makes sense
It worked like a charm. Thanks.
Post a Comment