Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> Migrate to index-organized tables
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
![]() |
![]() |