Re: dbms_stats and analyze 10g Release 2
- From: Mladen Gogala <mgogala@xxxxxxxxxxx>
- To: oracle-l@xxxxxxxxxxxxx
- Date: Tue, 19 Dec 2006 08:34:31 -0500
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
>
>
> =====================
>
> --
> //www.freelists.org/webpage/oracle-l
>
>
> --
> //www.freelists.org/webpage/oracle-l
>
>
>
--
Mladen Gogala
http://www.mladen-gogala.com
--
//www.freelists.org/webpage/oracle-l
Other related posts:
