DataPump Import (IMPDP) Throws Errors ORA-31693 ORA-936 On An Existing Table
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
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