How do I view which databases are available

[ProgrammingB52]

In MySQL it is
show databases; What is the command to view all of the databases available?

 

[Turkbear]

Hi,
Read the Oracle concepts manual ( and other Oracle docs at

http://tahiti.oracle.com

)..Oracle does not use the term database the same way as MySql..What you may be looking for is a listing of all the Tables you can access..The differences in process and even naming conventions between Oracle and other databases ( especially MySql and SqlServer) are substantial and will lead to confusion when trying to move from one to the other..This is a case where 'Read First..Act After' is very important.






To Paraphrase:"The Help you get is proportional to the Help you give.."

 

[SantaMufasa]

ProgrammingB52,

Turkbear is absolutely correct: Oracle's terminology (especially "database") differs from other database vendors' terminology. In MySQL, the "show databases" command displays the equivalent of Oracle's command:

select username from dba_users;

For non-Oracle database environments, database "users" (aka "logins") and the discrete collection of tables to which those logins may have default access (known as "databases" in the non-Oracle world, but known as "schemas" in the Oracle world) have no mutual dependencies. In the Oracle world, an Oracle "user" by definition has a "schema" by the same name. If you drop an Oracle user, then you also drop the schema ("database" for non-Oracle vendors) by the same name. An Oracle database user and the database schema by the same name are inextricable.

So, to see the list of Oracle users/schemas (roughly equivalent to MySQL "databases"), then you use the SELECT, above.

Mufasa
(aka Dave of Sandy, Utah, USA)

http://www.dasages.com

Do you use Oracle and live or work in Utah, USA?
Then click here to join Utah Oracle Users Group on Tek-Tips.

 

[ProgrammingB52]

Using select username from dba_users I get the error message ' table or view does not exist' Does that mean that there are no databases that I am privelaged to?

 

[Turkbear]

Hi,
No,It means you do not have access to the dba_tables table..
Try all_users or sys.dba_users..

If they fail, ask the Oracle DBA to grant your user account the needed privs..





To Paraphrase:"The Help you get is proportional to the Help you give.."