Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: missing tablespace_name
"Mark D Powell" <Mark.Powell_at_eds.com> wrote in message
news:1147110961.471044.294120_at_u72g2000cwu.googlegroups.com...
> Temporary tables and IOT tables do not have tablespace entries for
> starters.
>
> You might want to select the owner, table_name, iot_type, temporary
> from dba_tables where tablespace_name is null and take a look at what
> you get.
>
> HTH -- Mark D Powell --
>
Add partitioned table to that list.
(And for the benefit of the OP, the term IOT is short for Index Organized Table)
-- Regards Jonathan Lewis http://www.oracle.com/technology/community/oracle_ace/ace1.html#lewis The Co-operative Oracle Users' FAQ http://www.jlcomp.demon.co.uk/faq/ind_faq.html Cost Based Oracle: Fundamentals http://www.jlcomp.demon.co.uk/cbo_book/ind_book.htmlReceived on Mon May 08 2006 - 13:57:48 CDT