Unable to Import Workspace That Was Previously Deleted: "Workspace Exists and Will not be Created." (Doc ID 2181859.1)

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.

Symptoms

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

 

Other information

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?

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms