Home » SQL & PL/SQL » SQL & PL/SQL » TABLE TYPES with clustered (11g)
TABLE TYPES with clustered [message #604296] Fri, 27 December 2013 13:35 Go to next message
Sreekumarkv
Messages: 1
Registered: December 2013
Junior Member
I have a SQl Server udt table type with clustered index. how can i use it in oracle as it has got indexes only on physical tables
Re: TABLE TYPES with clustered [message #604299 is a reply to message #604296] Fri, 27 December 2013 13:50 Go to previous message
Michel Cadot
Messages: 65154
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

In Oracle what you call table with clustered index is named index organized table (IOT).

Previous Topic: UPDATE MULTIPLE ROWS IN ONE UPDATE PASS
Next Topic: Removing empty space
Goto Forum:
  


Current Time: Wed Aug 23 09:02:37 CDT 2017

Total time taken to generate the page: 0.06328 seconds