How to clone an APEX instance
625386Mar 4 2008 — edited Nov 19 2008What Is the procedure for cloning an existing APEX instance?
Specifically:
I have a database instance with APEX 3.0 installed and lots of apex applications running.
The data for the applications reside in various application schemas in the database instance.
The APEX repository resides in flows_030000 and flows_files and where else?
I want to move everything to a new database instance.
Can I do this:
Create new database with all of APEX prerequisites in place (target).
Export from old database
Import into the target database all applications schemas and flows_030000 and flows_files
I am referring to exp and imp, not exporting and importing individual applications within APEX.
Do I need to run apexins.sql on the target database?
Does apexins create database objects in other places other than flows_030000 and flows_files?
Thanks, Jack