Will Oracle ever follow its own advice?

From: Steve Howard <stevedhoward_at_gmail.com>
Date: Thu, 12 Feb 2009 09:32:29 -0800 (PST)
Message-ID: <fd671b52-0839-47a3-8e0e-004cbbc89ff9_at_b38g2000prf.googlegroups.com>



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> Received on Thu Feb 12 2009 - 11:32:29 CST

Original text of this message