EXP-00008: ORACLE error 1031 encountered,ORA-01031: insufficient privileges,ORA-06512: at "SYS.DBMS_EXPORT_EXTENSION", line 472

Visit the Below Website to access unlimited exam questions for all IT vendors and Get Oracle Certifications for FREE
http://www.free-online-exams.com

Problem: EXP-00008: ORACLE error 1031 encountered,ORA-01031: insufficient privileges,ORA-06512: at "SYS.DBMS_EXPORT_EXTENSION", line 472



Symptoms:
Full database export using export utility give the following warning messages:

EXP-00008: ORACLE error 1031 encountered
ORA-01031: insufficient privileges
ORA-06512: at "SYS.DBMS_EXPORT_EXTENSION", line 472
ORA-06512: at line 1
EXP-00078: Error exporting metadata for index CS_B_DOCUMENT_SUBJECT. Index creation will be skipped
EXP-00008: ORACLE error 1031 encountered
ORA-01031: insufficient privileges
ORA-06512: at "SYS.DBMS_EXPORT_EXTENSION", line 257
ORA-06512: at line 1
EXP-00078: Error exporting metadata for index CS_B_DOCUMENT_SUBJECT. Index creation will be skipped
EXP-00008: ORACLE error 1031 encountered
ORA-01031: insufficient privileges
ORA-06512: at "SYS.DBMS_EXPORT_EXTENSION", line 472
ORA-06512: at line 1
EXP-00078: Error exporting metadata for index CS_B_DOCUMENT_CON. Index creation will be skipped
EXP-00008: ORACLE error 1031 encountered
ORA-01031: insufficient privileges
ORA-06512: at "SYS.DBMS_EXPORT_EXTENSION", line 257
ORA-06512: at line 1


Solution:

Cause Determination === Insufficient grants.
Solution === Add grant to the objects.

follow the steps in Note:795492.1, EXP-83 EXP-8 ORA-1031 ORA-6512 On Export After Creating New Database, to check if it's solve your problem.

It's possible you get the problem described in Bug:5530761. For more information please read Note:5530761.8, Bug 5530761 - ORA-1031 from EXP of domain index. Please also read Note:405501.1, Export Ends With Warnings Exp-8 Ora-1031 Exp-78 Exp-78 after CPU install.

The bug is solved in Oracle 10.2.0.4, patch for Oracle 10.2.0.3 on Oracle Solaris on SPARC (64-bit) exist on following link:
http://updates.oracle.com/download/5530761.html

References:
Note:795492.1, EXP-83 EXP-8 ORA-1031 ORA-6512 On Export After Creating New Database

Get Oracle Certifications for all Exams
Free Online Exams.com