|Index Organized Tables (IOT) in Oracle - Save space and improve the performance of tables which are predominantly access by their primary keys.|
Donny said...Very nice site!
Oli Saffiullah said...Good...
Typo Boy said...s/UNCLUDING/INCLUDING/
The word "uncluding" seemed at first like some sweet new vocabulary ("You're uncluded pal, so hit the pike."), but then I saw it was a job . . . FOR TYPO BOY!
Pawel Barut said...This statement does not work:
ALTER TABLE table_name MOVE TABLESPACE iot_tablespace OVERFLOW TABLESPACE overflow_tablespace;
ALTER TABLE table_name ADD OVERFLOW TABLESPACE overflow_tablespace; (in Oracle 11g)
The command works just fine in 11gR2. If you read the line before it, it says if you want to move an existing overflow. The syntax you posted is for cresting a new overflow. :)