Menu
I wanted to delete some unused schemas on our oracle DB.
How can I query for all schema names ?
527
If you want to list all tables in the Oracle database, you can query the dba_tables view. SELECT table_name FROM dba_tables ORDER BY table_name ASC; This view (and all others starting with dba_) are meant for database administrators.
select owner, table_name from all_tables.
Using sqlplus
sqlplus / as sysdba
run:
SELECT * FROM dba_users
Should you only want the usernames do the following:
SELECT username FROM dba_users
173
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With
