Oracle 9i V$VERSION and changes to the system views for 9i

From: Joe Sanderson <joe.sanderson_at_ecora.com>
Date: Sat, 09 Jun 2001 19:14:12 -0700
Message-ID: <F001.00323465.20010609190523@fatcity.com>

Hello,
I have not yet tried my OCI based application on 9i (currently downloading...). I'm curious about the V$VERSION string that will be returned for 9i - I'm assuming that it will return something like:

"Oracle9i Enterprise Edition Release 9.0.6.0.0 - Production"

Can anyone confirm for me what is returned from "select * from v$version;"? As long as it starts with "Oracle9i" or something similar I'll be happy.

Also - can anyone out there who has tried 9i give me a heads up on how significantly any of the existing system views/tables have been changed? I'm not concerned about new tables/views, or new columns in tables. I would be concerned about any views that were removed or columns that were dropped
(hopefully there aren't any) over 8i. The primary one's I'm using are:

V$VERSION, V$ARCHIVE_DEST, V$BGPROCESS, V$CONTROLFILE, V$DATABASE,
V$INSTANCE, V$LOG, V$LOGFILE, V$NLS_PARAMETERS, V$OPTION, V$PARAMETER,
V$SGA, V$VERSION, DBA_PROFILES, DBA_ROLE_PRIVS, DBA_ROLES,

DBA_ROLLBACK_SEGS, DBA_SYS_PRIVS, DBA_TAB_PRIVS, DBA_TABLESPACES, DBA_USERS. Has anyone seen this documented anywhere - changes to the data dictionary in 9i?

Thanks
Joe Sanderson

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Joe Sanderson
  INET: joe.sanderson_at_ecora.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
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 Sat Jun 09 2001 - 21:14:12 CDT