| how we can export and import (one schema to other schema)in Oracle Application Express [message #255526] |
Wed, 01 August 2007 02:11  |
chzafar
Messages: 4
Registered: July 2007
Location: pakistan
|
Junior Member |
|
|
1- i get export of one application from application express.
2- i want to import that application to apex.oracle.com's user schema and workspace but it not import that exportfile.sql
(but it import within the same schema and workspace)
please tell me how can i import that exportfile.sql?
the following messate display.
ORA-20001: GET_BLOCK Error. ORA-20001: Execution of the statement was unsuccessful. ORA-20001: The procedure remove_flow was called without a value for p_id -- a application ID must be provided. <pre>begin -- Remove Application wwv_flow_api.remove_flow(); end; </pre>
regards
zafar
|
|
|
|
| Re: how we can export and import (one schema to other schema)in Oracle Application Express [message #256765 is a reply to message #255526] |
Mon, 06 August 2007 09:47  |
ava_ava
Messages: 2
Registered: August 2007
Location: New Delhi
|
Junior Member |
|
|
Hi,zafar
While importing application, there is point where you specify schema name,build status and application ID.
Select first redio button under "Install As Application" option. This is default option and automatically assign a new ID.
In your case, you are not assigning any application ID.That's why it's displaying that error.So, either you select "Auto Assign New Application ID" or select "Change Application ID" and provide new application ID.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
