Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: getting instance-name
Look in v$database. I think the column name is name or database...
Martin Haltmayer <Martin.Haltmayer_at_0800-einwahl.de> wrote in message
news:391EF3E6.E6E25A9_at_0800-einwahl.de...
> Hi Harald,
>
> in 8.1.5 you can call the function
>
> dbms_utility.active_instances
>
> and
>
> dbms_utility.current_instance
>
> Martin
>
>
>
> Harald Mitterhofer wrote:
> >
> > hi!
> >
> > is there a way to query the instance-name of the database in a
> > pl/sql-procedure running as a normal (non-dba-privileged) user?
> > I guess there is some system-view, but cannot find it;
> >
> > thanx;
> > mitt
>
Received on Sun May 14 2000 - 00:00:00 CDT