Re: dbms_stats and analyze 10g Release 2

From: Mladen Gogala <mgogala_at_verizon.net>
Date: Tue, 19 Dec 2006 08:34:31 -0500
Message-id: <1166535271l.3104l.0l@medo.noip.com>

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_at_freelists.org
> [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Kerber, Andrew
> Sent: Wednesday, December 13, 2006 6:31 PM
> To: joe_dba_at_hotmail.com; oracle-l_at_freelists.org
> 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

Received on Tue Dec 19 2006 - 07:34:31 CST