change default database [message #351749] |
Thu, 02 October 2008 16:48 ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
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
|
|
|
|
|
Re: change default database [message #351903 is a reply to message #351900] |
Fri, 03 October 2008 12:25 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
![](http://www.orafaq.com/forum/images/custom_avatars/102589.gif) |
Michel Cadot
Messages: 68680 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
|
|
|
|
|
|
|