Will Oracle ever follow its own advice?
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