Re: Why ALL_IND_COLUMNS.TABLE_NAME is VARCHAR2(4000)?

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: Tue, 15 May 2001 21:56:45 +0200
Message-ID: <tg32bu5f5i4r80@beta-news.demon.nl>

"NoSpam" <NoSpam_at_NoSpam.com> wrote in message news:9drt9e$ks4$1_at_ih292.ea.unisys.com...
> I had a hard time importing the ALL_IND_COLUMNS table from Oracle to
> MsAccess. Then I discovered the column TABLE_NAME in ALL_IND_COLUMNS has
an
> attribute of VARCHAR2(4000). Is this an Oracle bug?
>
>
>
>

No, this happens with all views where you have create view blabla as select <any varchar2 expression> So I would call it a feature, as it already exists for 12 years minimum. If you are convinced it is a bug, you are free to log a TAR with Oracle.

And why on earth do you import the Oracle datadictionary in Access? The Oracle datadictionary is readable from Access provided you have adequate privileges.

Hth,

Sybrand Bakker, Oracle DBA Received on Tue May 15 2001 - 14:56:45 CDT