Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Mailing Lists -> Oracle-L -> Re: Reason for upgrading from 8.1.7 to 9iR2
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_at_yahoo.com 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_at_freelists.org put 'unsubscribe' in the subject line. -- Archives are at http://www.freelists.org/archives/oracle-l/ FAQ is at http://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_at_freelists.org put 'unsubscribe' in the subject line. -- Archives are at http://www.freelists.org/archives/oracle-l/ FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html -----------------------------------------------------------------Received on Wed May 05 2004 - 14:36:36 CDT