Error: "DRG-10502: index ADMUSER"."DOCVER_DOCDATA_QSI does not exist" When Trying to Export a P6 Database Using the EXPDP Method (Doc ID 1989590.1)

Last updated on MARCH 30, 2017

Applies to:

Primavera P6 Enterprise Project Portfolio Management - Version 8.4.0.0 and later
Information in this document applies to any platform.

Symptoms

Primavera P6 Enterprise Project Portfolio Management (EPPM)

When attempting to export a database with the following script, the ERROR (below)occurs:

USERID="/ as sysdba"
DIRECTORY=DTPUMP
DUMPFILE=expdp_primtd03_primavera_schemas_031115_%U.dmp
JOB_NAME=primtd03_schemas_export
LOGFILE=expdp_primtd03_primavera_schemas_031115.log
SCHEMAS=ADMUSER,PRIVUSER,PUBUSER,PXRPTUSER,BGJOBUSER
PARALLEL=8


ERROR
-----------------------

ORA-39127: unexpected error from call to local_str := SYS.DBMS_EXPORT_EXTENSION.GET_DOMAIN_INDEX_METADATA('DOCVER_DOCDATA_QSI','ADMUSER84','TEXTINDEXMETHODS','CTXSYS',11.02.00.00.00,newblock,0)
ORA-20000: Oracle Text error:
DRG-10502: index ADMUSER"."DOCVER_DOCDATA_QSI does not exist
ORA-06512: at "SYS.DBMS_EXPORT_EXTENSION", line 270
ORA-06512: at line 1
ORA-06512: at "SYS.DBMS_METADATA", line 8360

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