Installing Apex Application in New Database Using SQLPlus Gives ORA-2291 On WWV_FLOWS_FK (Doc ID 949429.1)

Last updated on MARCH 01, 2016

Applies to:

Oracle Application Express (formerly HTML DB) - Version 2.0 to 4.1.00.28 [Release 2.0 to 4]
Information in this document applies to any platform.
Checked for relevance on 22-Nov-2011


Goal

When importing an export created by the APEXExport.class utility through SQL*Plus, the following
error occurs:

Set Application ID...
begin
*
ERROR at line 1:
ORA-02291: integrity constraint (APEX_030200.WWV_FLOWS_FK) violated - parent
key not found
ORA-06512: at "APEX_030200.WWV_FLOW_API", line 555
ORA-06512: at line 3


What is causing this error?

Solution

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