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.
>
> 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).
>
>
>
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> --
> Author:
> INET: Jared.Still_at_radisys.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).
>
Do you Yahoo!?
Yahoo! Mail Plus - Powerful. Affordable. Sign up now.
http://mailplus.yahoo.com
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Rachel Carmichael
INET: wisernet100_at_yahoo.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 Tue Jan 14 2003 - 20:44:02 CST