Re: Reason for upgrading from 8.1.7 to 9iR2
- From: "Gene Sais" <Gsais@xxxxxxxxxxxxxxxxxxx>
- To: <oracle-l@xxxxxxxxxxxxx>, <mhthomas@xxxxxxxxx>
- Date: Wed, 05 May 2004 15:37:08 -0400
Also, at 8.1.7. Researching whether to upgrade to 9.2.0.5 or to 10.1?
Anyone running 10g in production? Any issues, reasons not to upgrade to
10g?
Thanks,
Gene
>>> mhthomas@xxxxxxxxx 5/5/2004 3:29:33 PM >>>
I've seen 9iR2 upgrades driven by a globalization
thing rather than performance.
E.g. The UTF-8 support in 9iR2 is much nicer than 8i.
> explain the reasons for moving from 8.1.7 to 9iR2
E.g. in DBA_TAB_COLUMNS the CHAR_USED may be (B)YTES
or (C)HAR to differentiate multibyte characters:
--
DEFINE _O_VERSION = "Oracle9i Enterprise Edition
Release 9.2.0.4.0 - Production
With the Partitioning, Oracle Label Security, OLAP and
Oracle Data Mining options
JServer Release 9.2.0.4.0 - Production" (CHAR)
DEFINE _O_RELEASE = "902000400" (CHAR)
--
create table foo2
( col_char_size VARCHAR2 ( 3 CHAR ),
col_byte_size VARCHAR2 ( 3 BYTE ));
SQL> select char_length, data_length, char_used
1 from dba_tab_columns
2* where table_name = 'FOO2'
SQL> /
CHAR_LENGTH DATA_LENGTH C
----------- ----------- -
3 9 C
3 3 B
In 8i there were no CHAR semantics which caused
confusion on multibyte charactersets.
Regards,
Mike Thomas
__________________________________
Do you Yahoo!?
Win a $20,000 Career Makeover at Yahoo! HotJobs
http://hotjobs.sweepstakes.yahoo.com/careermakeover
----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx
put 'unsubscribe' in the subject line.
--
Archives are at //www.freelists.org/archives/oracle-l/
FAQ is at //www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------
----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx
put 'unsubscribe' in the subject line.
--
Archives are at //www.freelists.org/archives/oracle-l/
FAQ is at //www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------
Other related posts:
