Re: dbms_stats and analyze 10g Release 2

But, LONG columns are still here:

  1  select count(table_name) from dba_tab_columns
  2* where owner='SYS' and data_type like 'LONG%'
SQL> /

COUNT(TABLE_NAME)
-----------------
              223


Oracle uses long columns in data dictionary quite abundantly. My version is the 
latest and
the greatest:

SQL> select * from v$version;

BANNER
----------------------------------------------------------------
Oracle Database 10g Enterprise Edition Release 10.2.0.3.0 - Prod
PL/SQL Release 10.2.0.3.0 - Production
CORE    10.2.0.3.0      Production
TNS for Linux: Version 10.2.0.3.0 - Production
NLSRTL Version 10.2.0.3.0 - Production



On 12/19/2006 02:45:32 AM, Hallas, John wrote:
> They have been deprecated, not removed or updated. That is a manual
> process  
> 
> -----Original Message-----
> From: oracle-l-bounce@xxxxxxxxxxxxx
> [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Kerber, Andrew
> Sent: Wednesday, December 13, 2006 6:31 PM
> To: joe_dba@xxxxxxxxxxx; oracle-l@xxxxxxxxxxxxx
> Subject: RE: dbms_stats and analyze 10g Release 2
> 
> 
> 
> I don't think you have any long or long raw columns in 10g.  They have
> been deprecated in favor of the blob/clob.
> 
> 
> Andrew W. Kerber
> Oracle DBA
> UMB
> 
> 
> =====================
> 
> --
> http://www.freelists.org/webpage/oracle-l
> 
> 
> --
> http://www.freelists.org/webpage/oracle-l
> 
> 
> 

-- 
Mladen Gogala
http://www.mladen-gogala.com

--
http://www.freelists.org/webpage/oracle-l

Other related posts: