I have apex 4.2 connected thru pl/sql gateway, 11gr2 DB and using theme 25 cloudy.
I have 1 physical oracle DB where I installed apex. I create a new workspace WSA and created a new application with id 100.
I tried creating a new workspace WSB and when I created a new application with the same id of 100 I got an error that is must be unique.
Does this mean I can only have 1 application with id 100 per physical DB?
The reason I want to have the same application ID is I read a book that when you exp/imp you application it is better to keep the application id otherwise you would lose some data. Basically I'm trying to figure out how to update my DEVELOPMENT, QA and PRODUCTION environments.
I have 1 workspace and 1 app but I have 3 schemas. I is a parsing schema and the other 2 are identical schema where I store all of my tables. These 2 application schemas has the same table structure.
Schema: APEX is my parsing schema
Schema: APP1 has emp table
Schema: APP2 has emp table.
I have 1 interactive report based on the emp table and depending on the the user sometimes I need to access the APP1.emp and sometimes APP2.emp table.