OraFAQ Forum: Server Administration » change default database

Home » RDBMS Server » Server Administration » change default database (oracle 10g)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

change default database [message #351749]

Thu, 02 October 2008 16:48

sawsan
Messages: 15
Registered: October 2004

Junior Member

Hello

I installed oracle 10g on win xp, then I created two databases

Now I want to change the default database that launches when I start sqlplus...

how I can change the database ,that I am working on it, to another existed database
thanks a lot

Report message to a moderator

Re: change default database [message #351751 is a reply to message #351749]

Thu, 02 October 2008 18:38

ebrian
Messages: 2794
Registered: April 2006

Senior Member

If you actually want to change the default ORACLE_SID for the box you can change it in the registry and/or system environment variables. If you want to change it within the command prompt temporarily, then you can issue:

set oracle_sid=<new_sid_name>

Report message to a moderator

Re: change default database [message #351900 is a reply to message #351749]

Fri, 03 October 2008 12:16

sawsan
Messages: 15
Registered: October 2004

Junior Member

thanks

but can I ask you how can I know what database I am working on...

Report message to a moderator

Re: change default database [message #351903 is a reply to message #351900]

Fri, 03 October 2008 12:25

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

Senior Member
Account Moderator

SQL> select * from global_name;
GLOBAL_NAME
--------------------------------------------------------
MIKA.XXXXXXX

1 row selected.

SQL> select sys_context('userenv','db_name') from dual;
SYS_CONTEXT('USERENV','DB_NAME')
--------------------------------------------------------
MIKA

1 row selected.

Regards
Michel

[Updated on: Fri, 03 October 2008 12:26]

Report message to a moderator