Unable to Import Workspace That Was Previously Deleted: "Workspace Exists and Will not be Created."
Last updated on SEPTEMBER 16, 2016
Applies to:Oracle Application Express (formerly HTML DB) - Version 5.0.4.00.12 and later
Information in this document applies to any platform.
Copying workspace from DEVL to TEST database instances. Used APEX GUI to export. During the workspace import via GUI, a message that indicates that "workspace exists" and will not be created".
Both the DEVL and TEST environments are refreshed approximately once a month from PROD using the following method:
** The customer has a method they use where the refresh DEV and TEST from Prod
- Refresh the database from PROD
- Reinstall APEX
- Reinstall ORDS
- Import App / Workspaces
o APEX Version is 5.0.4.
o The APEX administration page shows only a the INTERNAL / ADMIN workspace and user exist in the installation. There are no other workspaces / users listed on the page.
o The same methodology has been used for several years and is done approximately once a month
- Dev was most recently refreshed Jun 9th
- Test was refreshed July 1st
How to get around this and keep the same workspace ID of 100050 and switch to a different primary schema?
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms