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: [EMAIL PROTECTED]
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: [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).
