snippetMinor
How do I discover the Oracle Express workspace name?
Viewed 0 times
expressthenamediscoverhoworacleworkspace
Problem
Is there a way to discover the WORKSPACE name if I've forgotten it?
I cannot login to the APEX admin console since I've forgotten what the workspace name was.
I do know the
Could you please help me recovering my workspace name?
I cannot login to the APEX admin console since I've forgotten what the workspace name was.
I do know the
SYSTEM user password.Could you please help me recovering my workspace name?
Solution
There are two tables you can get this info from.
The schema that these tables reside in depends on the APEX version. By way of example, my vanilla Oracle 11.2 install has them in the
APEX_WORKSPACES and APEX_APPLICATIONS.The schema that these tables reside in depends on the APEX version. By way of example, my vanilla Oracle 11.2 install has them in the
APEX_030200 schema. To list: select USERNAME from DBA_USERS where USERNAME like 'APEX%'.Context
StackExchange Database Administrators Q#25078, answer score: 7
Revisions (0)
No revisions yet.