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!

How to get tablespace of table without segment

RobertOrtelMar 18 2014 — edited Mar 20 2014

Hi,

I have some tables in 11.2 which have been created with deferred segment creation and so have no segment/extent yet. They already appear in dba_tables as well as tab$, but don't have a tablespace set.

However, using dbms_metadata.get_ddl() the resulting DDL has the correct tablespace name. But which view or table do I have to query to get this information with SQL?

Thanks

Robert

This post has been answered by RobertOrtel on Mar 20 2014

Jump to Answer

Locked Post

New comments cannot be posted to this locked post.

Locked on Apr 17 2014

Added on Mar 18 2014

#11g, #general-database-discussions

7 comments

1,310 views