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

Joe Sanderson wrote:
>
> 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
>

If I had a sun box at home, I would simply run a schema comparison against the data dictionaries.
(9.0.1.0.0 vs 8.1.7.1.2)
Anyone with 9i installed on a solaris box wanna open it up for a db_link for a little while? :)
(yeah, right).
create session and select on dict, all_tables, all_tab_columns ought to be sufficient.

I wonder - if the schema for user SYS (9i) could be exported and imported under another schema in 8i.
Interesting. I never attempted to export SYS. Ok - that works. Sounds like a risky operation to import sys' schema under another schema - if something ends up overwriting something else - gotta re-run catalog + catproc.
I'd ask for someone to provide an export of SYS' schema from 9.0.1 - but that probably violates a large number of clauses in the licensing agreement.

Guess I'll go look at Sun boxes on Ebay again - something smaller than an E250.

Paul

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Paul Drake
  INET: paled_at_home.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).