Re: Oracle 6 to 7 conversion

Kelly E. Harrelson wrote:
>
> Kirk Righter wrote:
> >
> > Heeeyyy,
> >
> > Can anybody out there point me in the right direction concerning
> > upgrading from Oracle 6 to 7? Any docs, articles, websites, etc.?
> >
> > Thanx,
> > Kirk (the newbie) Righter
>
> With each release of Oracle, they provide documentation about upgrading
> from previous versions. I have seen, specifically, the book you need. If
> you didn't receive the doc., call Oracle. But, I would start there.
>
> Good luck,
> Kelly

Hi,

Well the major differences will be basically in memory usage - you'll need more with Oracle7 (but then you get lots of additional stuff), data typing and executable program size - you'll want to recompile any Pro*C/Pro*Cobol stuff - if you have any. On the data typing side, Oracle 6 represents the CHAR datatype as an internal code which (can't remember which number - but it doesn't really matter) in Oracle7 equates to the datatype VARCHAR2 - so if trailing blanks are really important to you then this is one to watch out for. But yes, get hold of the Conversion manual published by Oracle Corp. Oracle7, although needing more memory also makes better use of it.

Cheers,

Martyn Jones
Iniciativa para Data Warehouse Received on Mon Oct 07 1996 - 00:00:00 CEST