Monday, 7 October 2024

Newly created Schemas not listed under APEX

 


Solution -  Add new schema to your APEX Workspace


BEGIN
   APEX_INSTANCE_ADMIN.ADD_SCHEMA('MY_WORKSPACE','HRM');
END;
/

See if the schema is listed, if not try the below and check again.


BEGIN  
    APEX_INSTANCE_ADMIN.UNRESTRICT_SCHEMA(P_SCHEMA => 'HRM');  
    COMMIT;  
END;
/




No comments:

Post a Comment