DataPump Import (IMPDP) Throws Errors ORA-31693 ORA-936 On An Existing Table (Doc ID 405206.1)

Last updated on NOVEMBER 28, 2016

Applies to:

Oracle Server - Enterprise Edition - Version 10.2.0.1 to 10.2.0.4 [Release 10.2]
Information in this document applies to any platform.
***Checked for relevance on 19-DEC-2012***

Symptoms

You try to import using DataPump Utility impdp and the job throws the following errors on already existing tables in the target database:

ORA-31693: Table data object "SYSADM"."PS_JOBCODE_TBL" failed to load/unload and is being skipped due to error:
ORA-00936: missing expression

The Import DataPump job will fail if:

1. The table has a LONG column (i.e.: the EXTERNAL TABLE access method cannot be used)

and:

2. The table has a unique index and import DataPump is done with:

CONTENT=DATA_ONLY TABLE_EXISTS_ACTION=TRUNCATE

(or APPEND if the table was truncated manually before the import DataPump started). This means that DIRECT PATH access method cannot be used either.

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