Home » RDBMS Server » Server Administration » guess between the two databases
guess between the two databases [message #62291] Tue, 13 July 2004 00:38 Go to next message
syed umair ali shah
Messages: 8
Registered: July 2004
Junior Member
hi there ... i want to ask you experts to solve my problem ... i have my tables and i dont know in which database they are in ... now when i see the services  in windows 2000 it says you have two databases ORC0 and ORCL so which one is correct and worth and which one is containing my tables and data ... plzzz it is urgent reply me soon ...

thanx in advance ...

Report message to a moderator

Re: guess between the two databases [message #62303 is a reply to message #62291] Tue, 13 July 2004 14:29 Go to previous messageGo to next message
Chris L
Messages: 7
Registered: January 2004
Junior Member
select * from v$instance;

that will tell you which instance you are currently connected to.

Then you could
select * from tab;

That would show you all tables and views that you own.

Report message to a moderator

Re: guess between the two databases [message #62312 is a reply to message #62291] Tue, 13 July 2004 22:10 Go to previous message
Anu
Messages: 82
Registered: May 2000
Member
connect to the user having dba privilege and type
show parameter db_name
u will get the database name u r connected currently
regards

Report message to a moderator

Previous Topic: OUI
Next Topic: ora-00405: Compatibility type "MV81"
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Thu Jan 09 03:50:24 CST 2025
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.