Re: Will Oracle ever follow its own advice?

From: Mark D Powell <Mark.Powell_at_eds.com>
Date: Thu, 12 Feb 2009 12:32:29 -0800 (PST)
Message-ID: <70201551-9609-4aff-b665-8d1ef4deb393_at_p13g2000yqc.googlegroups.com>

On Feb 12, 12:34 pm, gazzag <gar..._at_jamms.org> wrote:
> On 12 Feb, 17:32, Steve Howard <stevedhow..._at_gmail.com> wrote:
>
>
>
>
>
> > 11:05:39 oracle_at_wcasbuild01 ~ >sqlplus / as sysdba
>
> > SQL*Plus: Release 10.2.0.4.0 - Production on Thu Feb 12 12:30:28 2009
>
> > Copyright (c) 1982, 2007, Oracle.  All Rights Reserved.
>
> > Connected to:
> > Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bit
> > Production
> > With the Partitioning, OLAP, Data Mining and Real Application Testing
> > options
>
> > SQL> select count(*),owner from dba_tab_columns where data_type =
> > 'LONG' and owner like 'SYS%' group by owner;
>
> >   COUNT(*) OWNER
> > ---------- ------------------------------
> >         11 SYSTEM
> >        219 SYS
>
> > SQL>
>
> > C:\>sqlplus / as sysdba
>
> > SQL*Plus: Release 11.1.0.6.0 - Production on Thu Feb 12 12:30:43 2009
>
> > Copyright (c) 1982, 2007, Oracle.  All rights reserved.
>
> > Connected to:
> > Oracle Database 11g Enterprise Edition Release 11.1.0.6.0 - Production
> > With the Partitioning, OLAP, Data Mining and Real Application Testing
> > options
>
> > SQL> select count(*),owner from dba_tab_columns where data_type =
> > 'LONG' and owner like 'SYS%' group by owner;
>
> >   COUNT(*) OWNER
> > ---------- ------------------------------
> >         12 SYSTEM
> >        228 SYS
>
> > SQL>
>
> Do not as I do but do as I say! :)
>
> -g- Hide quoted text -
>
> - Show quoted text -

Based on a 9.2.0.6 database

 > select count(*) from dba_lobs where owner = 'SYS';

        29

On 10.2.0.3 I get
 > select count(*) from dba_lobs where owner = 'SYS';

  COUNT(*)

---

        94

New internal tables and new columns to existing internal tables appear to be using LOB data types.

It is anyone guess before Oracle is brave enough to convert existing long columns to LOB.

HTH -- Mark D Powell -- Received on Thu Feb 12 2009 - 14:32:29 CST