Forums | Aggregator | Books | Industry News | Firefox Plugins | Social | Links

Comments

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;

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

/Pawel

Tim... said...

Hi.

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

Cheers

Tim...
Prepared Statement Error: Table './oraclebasecms/cms_page_comment_uuids' is marked as crashed and should be repaired