Re: Replacement for v$instance
From: Roger Harris <rharris_at_kraft.com>
Date: 1995/12/04
Message-ID: <49utij$spg_at_nm3001.router.kraft.com>#1/1
Date: 1995/12/04
Message-ID: <49utij$spg_at_nm3001.router.kraft.com>#1/1
snufupagus_at_aol.com (Snufupagus) wrote:
>In Oracle 7.1.6 for Att Svr4 version there is a view
>v$instance which gives the startup day and time
>for your instance. I cannot find this view in 7.1.6
>for SCO or 7.1.4 for OS2. Does anyone know
>where to find or how to calulate the startup time
>for an instance?
I believe a bug existed in certain versions of 7.1 where the catalog.sql or utlmontr.sql scripts didn't create the public synonyms or grants for this view. Just create them yourself, following the example of the other v$ views. E-mail me if you need more details.
Roger Harris
rharris_at_kraft.com
DBA
Kraft Foods
White Plains, NY
Received on Mon Dec 04 1995 - 00:00:00 CET