Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Re: Oracle 9i V$VERSION and changes to the system views for 9i

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

From: Rachel Carmichael <carmichr_at_hotmail.com>
Date: Sun, 10 Jun 2001 18:00:57 -0700
Message-ID: <F001.00323920.20010610175523@fatcity.com>

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).



Get your FREE download of MSN Explorer at http://explorer.msn.com
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Rachel Carmichael
  INET: carmichr_at_hotmail.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 Sun Jun 10 2001 - 20:00:57 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US