OraFAQ Forum: SQL & PL/SQL » Where does the IOT and partitioned table go?

Home » SQL & PL/SQL » SQL & PL/SQL » Where does the IOT and partitioned table go?

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Where does the IOT and partitioned table go? [message #9771]

Thu, 04 December 2003 00:32

Sudhakar
Messages: 34
Registered: May 2002

Member

I created a IOT(Index Organised Table) and a partitioned table. Then I checked the Tablespace_name of those objects in the DBA_TABLES. Neither SYSTEM nor the default tablespace name is displayed. Can anyone please find it out and tell me?

Report message to a moderator

Re: Where does the IOT and partitioned table go? [message #9774 is a reply to message #9771]

Thu, 04 December 2003 01:27

William Robertson
Messages: 1643
Registered: August 2003
Location: London, UK

Senior Member

For IOTs the physical segment is the PK index. For partitioned tables check USER_TAB_PARTITIONS.

Report message to a moderator

Previous Topic:	how to know the update the a column?
Next Topic:	order member function

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Apr 19 14:24:57 CDT 2024