Re: Table that contains the Oracle_SID of the database ?
From: Oracle System Account <oracle_at_coulomb.pcc.oz.au>
Date: Fri, 18 Jun 93 03:05:22 GMT
Message-ID: <1993Jun18.030522.24700_at_coulomb.pcc.oz.au>
Date: Fri, 18 Jun 93 03:05:22 GMT
Message-ID: <1993Jun18.030522.24700_at_coulomb.pcc.oz.au>
Tony,
There is no such v$ table storing ORACLE_SID. However, you can still get ORACLE_SID by issuing the following:
SQLDBA> show parameter db_name
Regards
Peng Hu hu_at_coulomb.pcc.oz.au
Oracle DBA
Prospect Electricity
Sydney, Australia
Received on Fri Jun 18 1993 - 05:05:22 CEST