APEX 4.0.1.0.0.32
Moving app from one schema to another, ex TEST to DEV.
On import of an app - full app, not just a page - into DEV environment where the app id is NOT used in this database
and the workspace id's of the export-from and import-into workspaces are the same,
I am getting this error:
| Error | GET_BLOCK Error. |
| | ORA-20001: Execution of the statement was unsuccessful. ORA-00001: unique constraint (APEX_040100.WWV_FLOW_PAGE_PLUGS_PK) violated <pre>declare s varchar2(32767) := null; l_clob clob; l_length number := 1; begin s := null; wwv_flow_api.create_page_plug ( p_id=> 1749292960175163966 + wwv_flow_api.g_id_offset, p_flow_id=> wwv_flow.g_flow_id, p_page_id=> 108, p_plug_name=> 'Manage Laboratory', p_region_name=>'', p_escape_on_http_output=>'Y', p_plug_template |
I can import as a different app id.
I can import fine as the same app id in the source workspace.
We need to maintain the same app number to keep things in sync between DEV, TEST, QA and Prod environments.
What do I look for, for the cause of the problem, and to correct this problem?
Thank you - Karen