advise pls

[ohgie]

hi

i create new database ...so now i have two database
1.ORACLE (should be the default)
2. NEW_DB( i create this one using db config assistant)
my qestion is why i automatically connect to the one i create
when i sign on oracle sql/plus not to the default db_oracle....how can i make ORACLE the default database when i first sign on...

thanks guys

[sreddy]

What Operating System ?

You have to set ORACLE_SID and ORACLE_HOME to default it another database.

[SSundar]

Hi,

In Registry (HKEY_LOCAL_MACHINE -> SOFTWARE -> ORACLE), You will find key called LOCAL. If not found, create one and assign ORACLE (Your default database).

Thanks.

Sundar