Home » SQL & PL/SQL » SQL & PL/SQL » Tablespace of IOT table (Oracle9i Release 9.2.0.6.0)
Tablespace of IOT table [message #307794] Wed, 19 March 2008 23:12 Go to next message
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 #307808 is a reply to message #307794] Thu, 20 March 2008 01:01 Go to previous messageGo to next message
Michel Cadot
Messages: 64102
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
dba_tables.iot_type

Regards
Michel
Re: Tablespace of IOT table [message #308125 is a reply to message #307808] Fri, 21 March 2008 05:55 Go to previous messageGo to next message
ganeshsv
Messages: 51
Registered: January 2006
Member
HI Michel,

Thanks. However dba_tables.iot_type shows as "IOT". Its not displaying the tablespace of the IOT table.

thanks in advance,
GS
Re: Tablespace of IOT table [message #308126 is a reply to message #308125] Fri, 21 March 2008 06:00 Go to previous message
Michel Cadot
Messages: 64102
Registered: March 2007
Location: Nanterre, France, http://...
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
Previous Topic: ora-03001 unimplemented feature
Next Topic: Inheritance & nested tables
Goto Forum:
  


Current Time: Fri Dec 02 18:22:47 CST 2016

Total time taken to generate the page: 0.15975 seconds