The migration from DEV to PRD in APEX
Dear all,
Our time & Expense system which is built-up with APEX has go-live.
But now we got a big trouble on migrations.
You know we can not do any direct change in PRD. We have to implement those new requirements in DEV and carefully test them.
If they are OK, we will migrate it into PRD.
But as we all know, the trouble is you can not directly export a page and import a page in another workspace.
-----------------------------------------------------------------------------------------------------------------------------
I have found a trick. In exported file: 1. Change Workspace 2. Change application ID 3. change the "p_security_group_id"
I did successfully finished the testing once I learned this.
But the trouble came when I tried to import a page for an enhancment.
The apex allowes me to install the script but returns error as below:
ORA-20001: GET_BLOCK Error. ORA-20001: Execution of the statement was unsuccessful. ORA-00001: 违反唯一约束条件 (APEX_030200.WWV_FLOW_PAGE_PLUGS_PK) <pre>declare s varchar2(32767) := null; l_clob clob; l_length number := 1; begin s := null; wwv_flow_api.create_page_plug ( p_id=&gt; 42386927089347548 + wwv_flow_api.g_id_offset, p_flow_id=&gt; wwv_flow.g_flow_id, p_page_id=&gt; 1001, p_plug_name=&gt; 'Breadcrumb', p_region_name=&gt;'', p_plug_template=&am
("违反唯一约束条件" is chinese which means breaked the unique constraints.)
---------------------------------------------------------------------------------------------------------------------------
I think this migration should be a common problem for all the real-application-environment.
I really wonder why Oracle doesn't supply a mature solution for partial migration of application. Otherwise, the APEX will not be a friendly tool for application development. Do you think so?
I have to find a solution to migrate my enhancement now. How do you solve this tough trouble? Great thanks for any good idea.
Edited by: Gadfly on 2009-7-6 下午7:38