Re: Difference in Table and Table of Types

You can find the object tables in dba_object_tables; Related views are dba_types, dba_type_attrs, dba_nested_tables, dba_objects.

Regarding the TEMP tablespace, use the views v$tempfile and/or dba_temp_files;

"Bill Garcia" <garcia.wj_at_verizon.net> wrote in message news:9EMN8.45587$fM.19895_at_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 - 15:48:17 CDT