Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Tablespace name null

460544Aug 4 2006 — edited Aug 4 2006

select count(*),TABLESPACE_NAME from dba_tables where owner like 'TRF'
GROUP BY TABLESPACE_NAME;
I am getting 23 tables with null tablespace name .
only 5 out of 23 tables are index organized table .
Why other tables have null tablespace?

Locked Post

New comments cannot be posted to this locked post.

Locked on Sep 1 2006

Added on Aug 4 2006

#general-database-discussions

5 comments

3,622 views