Re: DB_name parameter

From: <hlarsick_at_my-dejanews.com>
Date: Wed, 15 Jul 1998 18:54:52 GMT
Message-ID: <6oitts$f4j$1@nnrp1.dejanews.com>

In article <35AB57D4.AE911AC_at_borg.com>, Vinnie <browns1_at_borg.com> wrote:
> Is there anyway to retrieve the db_name parameter in the pfile using
> SQL?
>
> Vinnie Salerno
> Litton/PRC
>
>

you can two things

select name from v$database (a view) to give this view access to everyone eiteher grant the view to public or a role/user to the people who need it
select value from v$parameter where name = 'db_name'

this will give you the instance name you used to create the database.

Harry Larsick
Jones Day

-----== Posted via Deja News, The Leader in Internet Discussion ==----- http://www.dejanews.com/rg_mkgrp.xp Create Your Own Free Member Forum Received on Wed Jul 15 1998 - 13:54:52 CDT