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 <[EMAIL PROTECTED]>
>To: Multiple recipients of list ORACLE-L
><[EMAIL PROTECTED]>
>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.
>
>
>--- [EMAIL PROTECTED] 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" <[EMAIL PROTECTED]>
>> Sent by: [EMAIL PROTECTED]
>> 01/14/2003 02:29 PM
>> Please respond to ORACLE-L
>>
>>
>> To: Multiple recipients of list
>ORACLE-L
>> <[EMAIL PROTECTED]>
>> 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: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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).
