Re: Indexes on Oracle8i Release 8.1.7.0.0 - Production

Użytkownik "Anthony Millard" <Anthony.Millard_at_Ramesys.Com> napisał w wiadomości news:6tfw7.38914$jE3.4415311_at_news6-win.server.ntlworld.com...
> Quick query,
> I have noticed that the size of the column field on ALL_IND_COLUMNS and
> USER_IND_COLUMNS is 4000 charatcers in length, but a column can only be 30
> characters.
> Does anyone know hwy there is such a bit difference in these 2 columns,
> surely the 4000 only neds to be 30.
> This is apperent on all 8 version databases we have installed.
>

Perhapse the UDF function is used as column in ALL_IND_COLUMN? Declaration of such a function returning varchar result cannot specify max length for the result, so max lenght of varchar2 is assumed (4000 chars).

Regards,
Andrzej Received on Mon Oct 08 2001 - 09:42:14 CDT