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

  • From: "Reidy, Ron" <Ron.Reidy@xxxxxxxxxxxxxxxxxx>
  • To: <BThomas@xxxxxxxxxx>, <oracle-l@xxxxxxxxxxxxx>
  • Date: Mon, 20 Dec 2004 17:02:38 -0700

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@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx]On Behalf Of Thomas Biju
Sent: Monday, December 20, 2004 4:34 PM
To: oracle-l@xxxxxxxxxxxxx
Subject: I was surprised, thought I'd share...

According to Oracle LONG and LONG RAW data types are deprecated (in =
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 =
 Oracle 10g 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@FTWT66OD> select * from v$version;

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


Biju Thomas


This electronic transmission and any attached files are intended solely =
 the person or entity to which they are addressed and may contain =
on that is privileged, confidential or otherwise protected from =
 Any review, retransmission, dissemination or other use, including =
taking a=3D
ny action concerning this information by anyone other than the named =
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.

This electronic message transmission is a PRIVATE communication which =
information which may be confidential or privileged. The information is =
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, =
or use of the contents of this information is prohibited. Please notify =
sender  of the delivery error by replying to this message, or notify us =
telephone (877-633-2436, ext. 0), and then delete it from your system.


Other related posts: