Tablespace of IOT table [message #307794] |
Wed, 19 March 2008 23:12  |
ganeshsv
Messages: 51 Registered: January 2006
|
Member |
|
|
HI,
Is there any data dictionary to identify the tablespace name of an Indexed Organized table?
In dba_tables its empty. Can you please help me?
thanks in advance
GS
|
|
|
|
|
Re: Tablespace of IOT table [message #308126 is a reply to message #308125] |
Fri, 21 March 2008 06:00  |
 |
Michel Cadot
Messages: 68737 Registered: March 2007 Location: Saint-Maur, France, https...
|
Senior Member Account Moderator |
|
|
IOT table does have tablespace as it is not a segment, a physical object.
You have to search for the associated index.
Generally speaking, tables and indexes are logical objects, segments are physical ones.
It is an Oracle error to put tablespace name in dba_tables/dba_indexes, it should only be in dba_segments.
Regards
Michel
|
|
|