Monday, May 6, 2013

Error While Creating a New Oracle APEX Workspace


Error provisioning sandbox.

ORA-00001:uniqueconstraint (APEX_040200.WWV_FLOW_PROV_COMPANY_NAME) violated

Fix:
            select COMPANY_NAME from APEX_040200.WWV_FLOW_PROVISION_COMPANY ;
            select SHORT_NAME from  APEX_040200.WWV_FLOW_COMPANIES;
            delete from apex_040200.WWV_FLOW_PROVISION_COMPANY where company_name='SANDBOX';

commit;
-- this resolves the issue

1 comment: