Revision history [back]
 | 1 | initial version |
You can use the following Oracle SQL Query to generate a list of all the Schemas present in a Database:
SELECT username
FROM dba_users
WHERE account_status = 'OPEN'
AND default_tablespace not in ('SYSTEM','SYSAUX');
This query will give you a list of all the active user accounts in the database that are not associated with the 'SYSTEM' and 'SYSAUX' tablespaces. These accounts represent the schemas in the database.