Re: Q: What is the easy way of 'sorting' a table physically?

Hi Mike,

Why do you want to sort the table physically? The reason I am asking is because Oracle does not guarantee the retrieval order nor will new records be inserted into the "correct" place in the table.

Why not create an index on the table and then use it to access the table?

Regards

Jerry

Mike C. wrote:
>
> Q: What is the easy way of 'sorting' a table physically?
>
> I've copy a table and tried this code below but unable to resort it...
> HELP!
>
> create table New_One as
> select *
> from Old_One
> order by First_Field
>
> Why is this not working??? Anyone??

--
Jerry Gitomer Since I know how to spell DBA I became one. jgitomer_at_p3.net Received on Thu Apr 09 1998 - 22:13:33 CDT