Re: Physical sort of a table

I !

  As far as I known, there is no others way if you want your data in a physical order but:

1- If the columns of a secondary index is good enough for your programs, you would have to drop/create the secondary index only. I did that with Ingres; the main table (data) was heap and the secondary was btree.

2- Disable all constraints and drop all indexes before reloading, you will save a lot of time.

3- In your Pro*C program, use array-insert. This is a VERY powerful feature.

4- Try SQL*LOADER; it may be faster (I am not sure).

5- Ask Oracle why they haven't include this basic feature.

  Good luck

-- 
  
Dominique Cloutier                  |___|      
DMR Quebec inc.	               __(X)_(_)_(X)__   
  		                    O ' O          
lamarcjp_at_dmr.ca                             \_/ 
(514-877-3301                               \#/  
                                             o     
Toutes ces opinions sont les miennes  All opinions are my own