How Do I Separate Development From Production Environment?
Answer»
Depending on requirements for the availability of the application, the size of the user population and other factors you can decide how to divide the development ENVIRONMENT from the production environment.
For certain applications, it is acceptable to combine the development server with the deployment server, as long as the END users understand that SOMETIMES the application is not available.
Other applications may require two (development and production) or even three (development, test and production) SERVERS.
In Application Express applications can be moved from environment to environment USING an export and import facility for application definitions.
With one server available to run the database and Application Express, you can still separate the development version of an application from its production version by using two workspaces accessing separate schemas.
In this case one workspace will be used by developers and the other will be the workspace in which the application is deployed in production.