| how can i locate the default oracle databases [message #62289] |
Mon, 12 July 2004 21:02  |
syed umair ali shah
Messages: 8
Registered: July 2004
|
Junior Member |
|
|
hi there ... i want to ask this question that how can i locate the default database in which my tables are saved ... i have a problem in locating because when i create table it never ask me where or in which database i need to save my tables ... plzzz help me in this regard ... also i connect SQL via scott/tiger ... so kindly do help me in this regard ...
thanx in advance ...
|
|
|
|
| Re: how can i locate the default oracle databases [message #62304 is a reply to message #62289] |
Tue, 13 July 2004 14:48  |
Chris L
Messages: 7
Registered: January 2004
|
Junior Member |
|
|
What type of OS?
On Unix type in env from you OS
look for the ORACLE_SID parameter. That is your default.
In Windows go to services and look for the Oracle process running 'OracleServiceSID' the SID is your default.
OR when you type in scott/tiger@thisstuff
'thisstuff' is your tnsnames entry which SHOULD be your SID but not necessarily.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
