Home » SQL & PL/SQL » SQL & PL/SQL » server databases
server databases [message #249394] Wed, 04 July 2007 04:51 Go to next message
logina
Messages: 11
Registered: June 2007
Location: hyd
Junior Member

hi all,
I am new to oracle. I am using oracle 10g.I am trying to change my database from sqlbase to oracle.
So in one option of my application i need to display all the databases of particular server.
I can do that in sqlbase by ( SHOW DATABASES ON SERVER SERVERNAME ).
Similarly i need this in oracle.
Any help please.
Thanks in advance
Re: server databases [message #249407 is a reply to message #249394] Wed, 04 July 2007 06:27 Go to previous messageGo to next message
Michel Cadot
Messages: 64117
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
select username from dba_users;
select distinct owner from dba_objects;


Regards
Michel
Re: server databases [message #249422 is a reply to message #249407] Wed, 04 July 2007 07:36 Go to previous messageGo to next message
logina
Messages: 11
Registered: June 2007
Location: hyd
Junior Member

hi Michel,
sorry i want not schema names. i want database names in that server.
Any help.
Thank you.
Re: server databases [message #249427 is a reply to message #249422] Wed, 04 July 2007 08:06 Go to previous messageGo to next message
Michel Cadot
Messages: 64117
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
You come from sql world I converted the terminology (database->schema).
There is no such command in Oracle.

Regards
Michel

Re: server databases [message #249775 is a reply to message #249427] Thu, 05 July 2007 18:11 Go to previous message
DreamzZ
Messages: 1666
Registered: May 2007
Location: Dreamzland
Senior Member
check your oratab file entry for databases..
Previous Topic: How to know the locks on a object and the user placed on it
Next Topic: IP adress from session id
Goto Forum:
  


Current Time: Tue Dec 06 04:41:51 CST 2016

Total time taken to generate the page: 0.07671 seconds