OraFAQ Forum: Backup & Recovery

Home » RDBMS Server » Backup & Recovery » Sid name (windows seven)

Thu, 29 April 2010 14:07

dgdevelopment2010
Messages: 4
Registered: April 2010
Location: Italy

Junior Member

there is a way to detect the "sid" in Oracle Database 10G Express Edition

Thu, 29 April 2010 14:10

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

SQL> select name from v$database;

NAME
---------
V102

usually it is "XE"

Thu, 29 April 2010 14:26

Michel Cadot
Messages: 68500
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

SQL> select instance_name from v$instance;
INSTANCE_NAME
----------------
mika

1 row selected.

Regards
Michel

Previous Topic:	rman duplicate
Next Topic:	Backup errors

Goto Forum:

]

Current Time: Sat Sep 23 21:46:08 CDT 2023