Skip to Main Content

APEX

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

How to change default schema of a workspace?

Michael HornSep 6 2012 — edited Sep 6 2012
We have a workspace associated with two schemas SCHEMA_A and SCHEMA_B. We started off (many years ago) with schema SCHEMA_A (default schema), later SCHEMA_B (additional schema) was added to the workspace. Unfortunately SCHEMA_A is no longer used, all the work is done in SCHEMA_B.

How do I change the default schema of a workspace? I found the following discussion (2190414 which solves the mystery of how to delete a schema association (last entry in the thread). One "simple" solution would be to drop the the current workspace and create a new one with the same name, however this is not feasible, as we have to many developers, applications and database servers, where we would have to implement those "changes".

Thanks in advance ...
This post has been answered by Hari_639 on Sep 6 2012
Jump to Answer

Comments

Processing
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Oct 4 2012
Added on Sep 6 2012
2 comments
2,024 views