Home » RDBMS Server » Backup & Recovery » Sid name (windows seven)
Sid name [message #453582] Thu, 29 April 2010 14:07 Go to next message
dgdevelopment2010
Messages: 4
Registered: April 2010
Location: Italy
Junior Member
there is a way to detect the "sid" in Oracle Database 10G Express Edition

Report message to a moderator

Re: Sid name [message #453583 is a reply to message #453582] Thu, 29 April 2010 14:10 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
 
SQL> select name from v$database;

NAME
---------
V102


usually it is "XE"

Report message to a moderator

Re: Sid name [message #453586 is a reply to message #453582] Thu, 29 April 2010 14:26 Go to previous message
Michel Cadot
Messages: 68767
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
 
SQL> select instance_name from v$instance;
INSTANCE_NAME
----------------
mika

1 row selected.

Regards
Michel

Report message to a moderator

Previous Topic: rman duplicate
Next Topic: Backup errors
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Sun Aug 24 21:12:19 CDT 2025
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.