ORA-00904 Raised While Running Full DataPump Import (IMPDP) (Doc ID 2017393.1)

Last updated on MARCH 16, 2017

Applies to:

Oracle Database - Enterprise Edition - Version 11.2.0.2 to 12.1.0.2 [Release 11.2 to 12.1]
Information in this document applies to any platform.

Symptoms

 During DataPump Import job execution, a create table statement fails with:

ORA-39083: Object type TABLE:"SYSMAN"."EM_JOB_TYPE_CREDS_INFO" failed to create with error:
ORA-00904: "SYS"."EM_JOB_CREDSET_LIST": invalid identifier
Failing sql is:
CREATE TABLE "SYSMAN"."EM_JOB_TYPE_CREDS_INFO" ("JOB_TYPE_ID" RAW(16) NOT NULL ENABLE, "USAGE" VARCHAR2(64 BYTE) NOT NULL ENABLE, "AUTH_TARGET_TYPE" VARCHAR2(64 BYTE) N
OT NULL ENABLE, "CREDENTIAL_TYPES" "SYSMAN"."EM_JOB_CREDSET_LIST" , "CREDENTIAL_SETS" "SYSMAN"."EM_JOB_CREDSET_LIST" DEFAULT "SYS"."EM_JOB_CREDSET_LIST"(), "DEFAULT_CR
ED_SET" V

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