Wednesday, March 26, 2008

EXP-00008: ORACLE error 6550 encountered

Hi,

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:

siva said...

Wow - works like a miracle.
Really good solution.
Thanks.

Anonymous said...

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

Anonymous said...

Thanks sergio, U.B.D.Man

Chilli Honey said...

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

Toksy said...

Thanks a lot. This works and it makes sense

Anonymous said...

It worked like a charm. Thanks.