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

Rachel,

there is that small issue of not having a solaris box

• and 9i for wintel or Linux won't be out for awhile ...

didn't see anything I liked on Ebay in Sun hardware, either.

Paul

Rachel Carmichael wrote:
>
> Paul,
>
> the export worked... now import it into a different schema, if all you want
> to do is look at it. Heck, import it as rows=n fromuser/touser
>
> Rachel
>
> >From: Paul Drake <paled_at_home.com>
> >Reply-To: ORACLE-L_at_fatcity.com
> >To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>
> >Subject: Re: Oracle 9i V$VERSION and changes to the system views for 9i
> >Date: Sun, 10 Jun 2001 07:15:23 -0800
> >
> >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).