ORA-02291 when Importing Portal.WWDOC_DOCUMENT$

(Doc ID 1113422.1)

Last updated on DECEMBER 08, 2016

Applies to:

Portal - Version 10.1.2.0.1 to 10.1.4.2 [Release 10gR2]
Information in this document applies to any platform.
Checked for relevance on 23-Apr-2015

Symptoms

Migrating Portal from one host to another by only exporting and importing a single table called WWDOC_DOCUMENT$.
The following errors are reported when trying to import the content of the WWDOC_DOCUMENT$ table:

Export file created by EXPORT:V10.02.01 via conventional path
import done in US7ASCII character set and AL16UTF16 NCHAR character set
import server uses WE8ISO8859P1 character set (possible charset conversion)
. importing PORTAL's objects into PORTAL
. . importing table "WWDOC_DOCUMENT$"
IMP-00019: row rejected due to ORACLE error 2291
IMP-00003: ORACLE error 2291 encountered
ORA-02291: integrity constraint (PORTAL.WWDOC_DOCU_FK) violated - parent key not found

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