Re: V$VERSION on 9i, and question about changes to system views in 9i

Joe,

You are correct, on the release I played with, the banner at the start said:

"Oracle9i Enterprise Edition Release 9.0.0.0.0 - Beta" This will obviously change when it goes production.

As to the changes in the V$ views, there are plenty of additional columns in many of them I suggest you look at the newest 9i documentation they have on technet. Look in the Server Reference

Regards.
Samantha

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? As long as it starts with
> "Oracle9i" or something similar I'll be happy.
>
> Also - can anyone out there who has tried 9i let me know 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
> 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
Received on Mon Jun 11 2001 - 14:07:24 CDT