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***
You try to import using DataPump Utility impdp and the job throws the following errors on already existing tables in the target database:
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)
2. The table has a unique index and import DataPump is done with:
(or APPEND if the table was truncated manually before the import DataPump started). This means that DIRECT PATH access method cannot be used either.
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