Re: Will Oracle ever follow its own advice?

From: gazzag <gareth_at_jamms.org>
Date: Thu, 12 Feb 2009 09:34:59 -0800 (PST)
Message-ID: <8a4beca5-fee6-4897-953e-21966c8d7006_at_c12g2000yqj.googlegroups.com>

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