Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Migrate to index-organized tables

Migrate to index-organized tables

From: <blair_at_pjm.com>
Date: Wed, 20 Dec 2000 15:40:09 -0500
Message-Id: <10716.125033@fatcity.com>


I have a some gigantic tables that we want to re-organize as index-organized tables. How do I do the migration of data from the old tables into the new index-organized tables? Will "Insert into new-table select * from old-table;" work??

Any other info (esp. gotchas) on index-organized tables in 8.1.6 would be helpful.

thanks,

..tom Received on Wed Dec 20 2000 - 14:40:09 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US