RE: Re: Run obsolete Oracle 7 scripts against Oracle 8i database?

Stephane - If you ever take the OCP 9i upgrade exam, you'll want to be very clear on 07_DICTIONARY_ACCESSIBILITY. Here is the definition:

Setting this TRUE (default before 9i) means users with SELECT ANY can read any objects owned by SYS (data dictionary.

So if your users have scripts that read the data dictionary, those scripts won't work in 9i. I believe you can grant "select catalog role" and fix that. Or set O7_DICTIONARY_ACCESSIBILITY = FALSE.

Dennis Williams
DBA, 40%OCP
Lifetouch, Inc.
dwilliams_at_lifetouch.com

-----Original Message-----
Sent: Wednesday, January 15, 2003 3:09 AM To: Multiple recipients of list ORACLE-L database?

v$instance changed a lot. Otherwise Jared is right about #, which was mostly appended to (number) columns named 'TYPE' (became a reserved word in 8.x, thanks to the $£ùàç?%* object option) (in sys.obj$, sys.user$ most notably, possibly sys.seg$ too - perhaps sys.con$ or sys.cdef$ as well, can't remember).
To answer the original question more precisely, there is a O7_DICTIONARY_ACCESSIBILITY init.ora parameter (in 8 and 8i at least), but I am still unclear about its exact meaning and purpose.

>----- Original Message -----
>From: Rachel Carmichael <wisernet100_at_yahoo.com>
>To: Multiple recipients of list ORACLE-L
><ORACLE-L_at_fatcity.com>
>Sent: Tue, 14 Jan 2003 18:44:01
>
>some of the dba_ views changed as well. Can't
>remember them offhand, I
>know when we were doing the 101 book, we flagged
>new or different or
>obsolete columns when we discussed those views.
>
>
>--- Jared.Still_at_radisys.com wrote:
>> As long as you aren't using any x$ views or sys.$
>tables, they
>> should work as is, with a minimum of exceptions.
>>
>> There were some v$ views that changed,
>v$log_history for instance.
>>
>> There were also some cases of '#' being added to
>some column
>> names, but I can't recall which views those were.
>
>>
>> Jared
>>
>>
>>
>>
>>
>>
>> "Kaing, Leng" <Leng.Kaing_at_team.telstra.com>
>> Sent by: root_at_fatcity.com
>> 01/14/2003 02:29 PM
>> Please respond to ORACLE-L
>>
>>
>> To: Multiple recipients of list
>ORACLE-L
>> <ORACLE-L_at_fatcity.com>
>> cc:
>> Subject: Run obsolete Oracle 7
>scripts against Oracle
>> 8i database?
>>
>>
>> Hi Guys,
>>
>> In OEM reports, under the ELEMENTS tab, you can
>specify "Table from
>> SELECT
>> statement for database versions". ie. the minimum
>version of the
>> database
>> for which a script will run. So you can have
>scripts that used to
>> work in
>> Oracle 7 and still have it run in Oracle 8i. ie.
>Even though the
>> scripts
>> now uses obsolete views or
>> columns, they will still work against an Oracle
>8i database.
>>
>> So how do we go about doing a similar thing in
>SQL*Plus? ie. get
>> obsolete
>> Oracle 7 scripts to run against Oracle 8i
>database in SQL*Plus? I'd
>> like
>> to test out my scripts in SQL*Plus before
>modifying the OEM reports.
>>
>> TIA,
>>
>> Leng.

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Stephane Faroul
  INET: sfaroult_at_oriolecorp.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).

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: DENNIS WILLIAMS
  INET: DWILLIAMS_at_LIFETOUCH.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).