Re: ORA_SID in Sql*Plus?
From: Morris Galloway <mmgall_at_presby.edu>
Date: 1996/10/30
Message-ID: <3277DC10.4732_at_presby.edu>#1/1
Date: 1996/10/30
Message-ID: <3277DC10.4732_at_presby.edu>#1/1
John Verhoeven wrote:
>
> In article dated Mon, 28 Oct 1996 09:40:42 -0800, Halina Monka (toyr002_at_ibm.net) wrote:
> > column DBNAME new_value DB noprint
> > select value dbname from v$parameter
>
> But this only works if you can access this table. A person with a DBA
> role can but not your average user.
We created a table with one row and column, put the sid in it, granted
select to public, etc.
It means you have to be careful if you export/import to clone a
database, but it works.
-- Morris Galloway Jr. Tel: 864-833-8217 Dean, Administrative Services Fax: 864-833-8481 Presbyterian College Email: mmgall_at_presby.edu Clinton, SC 29325 http://web.presby.edu/~mmgallReceived on Wed Oct 30 1996 - 00:00:00 CET