Oracle-L: (no subject)

From: Kaing, Leng <Leng.Kaing_at_team.telstra.com>
Date: Thu, 16 Jan 2003 14:42:19 -0800
Message-ID: <F001.005323F7.20030116144219@fatcity.com>

Hi Stephane,

Thanks for the attempt.

When I saw the O7_DICTIONARY_ACCESSIBILITY I thought it would be the answer. Unfortunately Dennis Williams is right in saying that this parameter only allows users with SELECT ANY TABLE privileges to also see SYS tables.

Short of changing my scripts for different version of Oracle due to obsolete columns and values, I was trying to see how OEM could easily just nominate a minimum database version and ensure that the script still works against a higher version of Oracle.

Unfortunately I haven't been able to find a way of doing so :-(

Leng.

From: "Stephane Faroult"<sfaroult_at_oriolecorp.com> Date: Wed, 15 Jan 2003 09:06:26 UT
Subject: RE: Re: Run obsolete Oracle 7 scripts against Oracle 8i databas= e?

v$instance changed a lot. Otherwise Jared is right about #, which was mos=
tly appended to (number) columns named 'TYPE' (became a reserved word in =
8.x, thanks to the $=A3=F9=E0=E7?%* object option) (in sys.obj$, sys.user=
$ most notably, possibly sys.seg$ too - perhaps sys.con$ or sys.cdef$ as =

well, can't remember).=20
To answer the original question more precisely, there is a O7_DICTIONARY_ACCESSIBILITY init.ora parameter (in 8 and 8i at least), bu= t I am still unclear about its exact meaning and purpose.

Leng Kaing
Email: leng.kaing_at_team.telstra.com
Phone: +61-417-371-348

--

Please see the official ORACLE-L FAQ: http://www.orafaq.net
--

Author: Kaing, Leng
INET: Leng.Kaing_at_team.telstra.com

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------

To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). Received on Thu Jan 16 2003 - 16:42:19 CST