Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Difference in Table and Table of Types
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