Since couple of days, I have set cron job for oracle 11g database backup with the export utility. Every export backup, i have encountered “ORA-06510: PL/SQL: unhandled user-defined exception” & “ORA-06512: at SYS.DBMS_EXPORT_EXTENSION” warnings.

After searching web, I came to know that user who has backup oracle database is ordinary user & user having lack of execute privileges that: DBMS_EXPORT_EXTENSION and DBMS_DEFER_IMPORT_INTERNAL.

After granting above mentioned privileges, no more warnings have been observed in export log files & issue has been sorted out.

 

Warnings i have encounted in export log file is as below:
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

 

Following query will ensure the total privileges assigned to EXPORT user.

SQL> select grantee,owner,table_name,privilege from dba_tab_privs where grantee=’BACKUPADMIN’;

no rows selected

 

Following query will grant required privilage to EXPORT user.

 

SQL> grant execute on DBMS_EXPORT_EXTENSION to BACKUPADMIN;

Grant succeeded.

SQL> grant execute on DBMS_DEFER_IMPORT_INTERNAL to BACKUPADMIN;

Grant succeeded.

 

Invoke same query to ensure changes:

SQL> select grantee,owner,table_name,privilege from dba_tab_privs where grantee=’BACKUPADMIN’;

GRANTEE OWNER TABLE_NAME PRIVILEGE
—————————— —————————— —————————— —————————————-
BACKUPADMIN SYS DBMS_DEFER_IMPORT_INTERNAL EXECUTE
BACKUPADMIN SYS DBMS_EXPORT_EXTENSION EXECUTE

************************************************************************

Note: Please don’t hesitate to revert in case of any query OR feedback.

Thanking you.

Have a easy life ahead.