SCHEMAS: Error re-assigning schema to a different workspace

SITUATION
- Apex 4.0 on 11g
- Trying to edit workspace to schema assignments
- Following instructions here (http://download.oracle.com/docs/cd/B28359_01/appdev.111/b32258/adm_wrkspc.htm#BABBEEGC)
- Have done this successfully before
ERROR
Get the following error
ORA-20505: Error in DML: p_rowid=23878801718644742, p_alt_rowid=ID, p_rowid2=, p_alt_rowid2=. ORA-00001: unique constraint (APEX_040000.WWV_FLOW_COMPANY_SCHEMAS_IDX2) violated
HELP!
- Suggestions on how to diagnose and fix
- The schema name is unique
Advertisement
Reply

resolved some time ago