Home » RDBMS Server » Server Administration » how to check database name?
how to check database name? [message #50582] Fri, 22 March 2002 07:35 Go to next message
watermelon
Messages: 1
Registered: March 2002
Junior Member
I am using Oracle 9i personal edition on win98.

I logon SQLplus with id = system. Then i create a new table immediately.

How can i check which database contains this new table?

Report message to a moderator

Re: how to check database name? [message #50584 is a reply to message #50582] Fri, 22 March 2002 09:18 Go to previous message
Sanjay Bajracharya
Messages: 279
Registered: October 2001
Location: Florida
Senior Member
select name from v$database;

Report message to a moderator

Previous Topic: Reg Importing
Next Topic: Plan does not change after importing stats
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Tue Dec 24 22:49:05 CST 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.