Tuesday, October 4, 2011

Export Ends With Warnings Exp-8 Ora-1031 Exp-78 Exp-78 after CPU install

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: Export Ends With Warnings Exp-8 Ora-1031 Exp-78 Exp-78 after CPU install


Symptoms:
Export of schemas which contain domain indexes it is failing after the instalation of CPU from
Jul. or Oct. 2006.

The export it is terminating with warnings but the content indexes are not exported due the following error on SYS.DBMS_EXPORT_EXTENSION:

ORA-01031: insufficient privileges
While exporting bitmap, functional and extensible indexes
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 ACTIONDES_TIDX. Index creation will be skipped

Recently started receiving the errors messages above when doing an export using a non sys or
system user after upgrading from 10.2.0.1 to 10.2.0.3.



Solution:


Cause
BUG:5530761 CPUJUL2006: EXPORT UNABLE TO EXPORT DOMAIN INDEXES
After the installation of CPUJUL2006 on top of 10.2.0.2 the export it is unable to access all the tables even if the user has EXP_FULL_DATABASE role. The export tool is giving warnings on the tables which have context indexes attached.

The BUG is fixed by development on version 11.1 and 10.2.0.4.
Solution
To resolve the problem and export all the objects you have the following options:

To implement the solution, please execute the following steps:


1- Bug 5530761 is fixed in 11.1 and 10.2.0.4 .

2- The workaround is to grant 'select any table' privilege to the exporting user.

3-Apply Patch 5530761 if available

References:

Export Ends With Warnings Exp-8 Ora-1031 Exp-78 Exp-78 after CPU install [ID 405501.1]

BUG:5530761 - CPUJUL2006: EXPORT UNABLE TO EXPORT DOMAIN INDEXES
PATCH:5530761 - CPUJUL2006 EXPORT UNABLE TO EXPORT DOMAIN INDEXES

Get Oracle Certifications for all Exams
Free Online Exams.com

No comments: