APEX

Hi !

I am trying to have a development and a production area for my APEX app so I tried to make a copy of the app with all tables and data to another server.

I am frustrated with the process .

What should be a one click operation, it's taking me an entire day already and I still have not succeeded !

What I did is this:

on the source server I go to:

1. SQL Workshop > Utilities > Generate DDL

2. I select all relevant tables, views, indexes, materialized views (but I skip the .... and generate the script

Few problems with the generated script:

The individual Database links cannot be selected so they are not generated, even though I checked to include "Database links" !

I also have a materialized view and see that it is created as a table:

CREATE TABLE  "MANAGEMENT_TREE" ...

And at the end of the DDL file:

CREATE MATERIALIZED VIEW  "MANAGEMENT_TREE"

Is this normal ????

3. I go to the application which I want to export

•     Click on Supporting Objects.

•     Click on Installation Script.

•     Click on Create From File.

And add the DDL script from step 2.

4. Export the application

On the destination server:

I import the file created in step 4 and run the install script.

But the big problems is that

I get errors like these for may of the commands:

ORA-00406: COMPATIBLE parameter needs to be 12.0.0.0.0 or greater

ORA-00722: Feature “Editions"

Both APEX servers run on the same version, same output for SELECT * FROM V$VERSION:

Any ideas how to solve something that should be simple, and I have to do frequently ?