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 ...