Re: Difference in Table and Table of Types

From: Bill Garcia <garcia.wj_at_verizon.net>
Date: Wed, 12 Jun 2002 18:44:21 GMT
Message-ID: <9EMN8.45587$fM.19895@nwrddc01.gnilink.net>

For my last post TABLE created of TYPE questions. I should have included the Oracle Version 9i Enterprise on NT.

Bill Garcia
Tampa Florida

"Bill Garcia" <garcia.wj_at_verizon.net> wrote in message news:VqMN8.45536$fM.19250_at_nwrddc01.gnilink.net...
> At a glance a Table and a Table created as a table of types seem to be
> identical. However it appears that a table created of a type does not show
> up in USER_TABLES, ALL_TABLES, or DBA_TABLES. I don't understand that.
But
> then I don't understand why TEMP tablespaces are not kept in
DBA_DATA_FILES.
> What is the difference in a TABLE and a TABLE created of type. Would you
> care to expound on the location of dictionary data on TABLES created of
> type.
>
>
> Thanks
> Bill Garcia
> Tampa Florida
>
>
Received on Wed Jun 12 2002 - 13:44:21 CDT