RE: I was surprised, thought I'd share...

From: Reidy, Ron <Ron.Reidy_at_arraybiopharma.com>
Date: Mon, 20 Dec 2004 17:02:38 -0700
Message-ID: <17CAB0BF27BCFC47B0E4554A0E2F962B4391D3@fiji.arraybp.com>

A classic example of "Do as we say, not as we do!".

Ron Reidy
Lead DBA
Array BioPharma, Inc.

-----Original Message-----
From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org]On Behalf Of Thomas Biju Sent: Monday, December 20, 2004 4:34 PM
To: oracle-l_at_freelists.org
Subject: I was surprised, thought I'd share...

According to Oracle LONG and LONG RAW data types are deprecated (in = Oracle8=3D
i) and "we" should convert them to appropriate LOB data types. And there are procedures to convert them too...

The following SQL is run on a brand new (not upgraded from earlier = version)=3D
Oracle 10g 10.1.0.3 database:

system> select data_type, count(*)
  2 from dba_tab_columns
  3 where DATA_TYPE like 'LONG%'
  4 and owner =3D3D 'SYS'
  5* group by data_type
system> /

DATA_TYPE COUNT(*)

-------------------- ----------
LONG                        209
LONG RAW                      4

system_at_FTWT66OD> select * from v$version;

BANNER

Oracle Database 10g Enterprise Edition Release 10.1.0.3.0 - 64bi PL/SQL Release 10.1.0.3.0 - Production
CORE 10.1.0.3.0 Production
TNS for Solaris: Version 10.1.0.3.0 - Production NLSRTL Version 10.1.0.3.0 - Production

system_at_FTWT66OD>

Thanks,
Biju Thomas
DBA

_________________________________________________________________________=

__=3D

This electronic transmission and any attached files are intended solely = for=3D
the person or entity to which they are addressed and may contain = informati=3D
on that is privileged, confidential or otherwise protected from = disclosure.=3D
Any review, retransmission, dissemination or other use, including = taking a=3D
ny action concerning this information by anyone other than the named = recipi=3D
ent, is strictly prohibited. If you are not the intended recipient or = have =3D
received this communication in error, please immediately notify the = sender =3D
and destroy this communication.

--
http://www.freelists.org/webpage/oracle-l

This electronic message transmission is a PRIVATE communication which =
contains
information which may be confidential or privileged. The information is =
intended=20
to be for the use of the individual or entity named above. If you are =
not the=20
intended recipient, please be aware that any disclosure, copying, =
distribution=20
or use of the contents of this information is prohibited. Please notify =
the
sender  of the delivery error by replying to this message, or notify us =
by
telephone (877-633-2436, ext. 0), and then delete it from your system.

--
http://www.freelists.org/webpage/oracle-l

Received on Mon Dec 20 2004 - 18:00:55 CST