Re: Long columns obsolete

From: Daniel Morgan <damorgan_at_x.washington.edu>
Date: Sat, 06 Dec 2003 08:19:35 -0800
Message-ID: <1070727610.410748@yasure>

Sybrand Bakker wrote:

> On Sat, 6 Dec 2003 07:23:46 -0500, "Mark C. Stock" <mcstockX_at_Xenquery
> .com> wrote:
>
>

>>Good advise. I suppose eventually Oracle will follow it. ;-{)

>
>
>
> Probably with the same speed as they implemented CBO for the
> dictionary, so there are a few major releases to go.
>
>
> --
> Sybrand Bakker, Senior Oracle DBA

SQL> SELECT owner, COUNT(*)

   2 FROM dba_tab_columns
   3 WHERE data_type LIKE 'LONG%'
   4 GROUP BY owner
   5 /

In 10g produces more than 200 positive responses.

-- 
Daniel Morgan
http://www.outreach.washington.edu/ext/certificates/oad/oad_crs.asp
http://www.outreach.washington.edu/ext/certificates/aoa/aoa_crs.asp
damorgan_at_x.washington.edu
(replace 'x' with a 'u' to reply)

Received on Sat Dec 06 2003 - 10:19:35 CST