8i | 9i | 10g | 11g | 12c | 13c | 18c | 19c | Misc | PL/SQL | SQL | RAC | WebLogic | Linux

Home » Misc » Here

Comments for Index Organized Tables (IOT) in Oracle

Donny said...

Very nice site!

Oli Saffiullah said...


Typo Boy said...


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;

Should be:
ALTER TABLE table_name ADD OVERFLOW TABLESPACE overflow_tablespace; (in Oracle 11g)


Tim... said...


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. :)



DO NOT ask technical questions here! They will be deleted!

These comments should relate to the contents of a specific article. Constructive criticism is good. Advertising and offensive comments are bad and will be deleted!

If you post personal information (name, email address etc.) you are agreeing to them being stored and displayed. Feel free to remain anonymous.