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