Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> RE: I was surprised, thought I'd share...
It will eventually go away....just like logging in as svrmgrl
The started telling us in 7.2 (IIRC) that svrmgrl would eventually be phased out and that starting with 8i, we should be using sqlplus / as sysdba
Well, it stayed around until 9i when they no longer shipped it with the database....
Just trying to give you ample chane to hang yourself with it.....
-----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 5: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
system_at_FTWT66OD>
Thanks,
Biju Thomas
DBA
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
--
http://www.freelists.org/webpage/oracle-l
Received on Mon Dec 20 2004 - 17:45:22 CST
![]() |
![]() |