NAME IS ALREADY USED BY AN EXISTING OBJECT WHEN CREATING A NEW WORKSPACE in APEX 

I followed instructions for creating a new workspace in APEX. I chose the option of using an already existing schema.  However, the creation failed for certain schemas but succeeded for others.

After researching the problem with Oracle it turned out that creating a new workspace automatically create DEPT , EMP and other object.  If it so happened that your schema already has DEPT , EMP or any of the other objects that the workspace creates , then the creation process is doomed to fail.

In my case, a VIEW called DEPT existed, i had to drop the VIEW , Create the Workspace, drop the DEPT table created by the workspace procedures then recreate the view.

 

Please note that one can use also another option to avoid this error:
A. Choose not to create the Sample Application
1. In the Apex Administration go to:
Manager Service - > Feature Configuration
2. Go to the "Application Development" and select "No" for the "Create demonstration objects
in new workspaces

 

Ammar Sajdi

April 3, 2009

Note:  Oracle added a note for that particular problem

Note 800250.1 "ORA-00955: Name Is Already Used By An Existing Object" When Creating
A New Workspace