Export Ends With Warnings Exp-8 Ora-1031 Exp-78 Exp-78 after CPU install (Doc ID 405501.1)

Last updated on NOVEMBER 28, 2016

Applies to:

Oracle Server - Enterprise Edition - Version: 10.2.0.1
This problem can occur on any platform.

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.

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms