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

Home -> Community -> Usenet -> c.d.o.misc -> Q: What is the easy way of 'sorting' a table physically?

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

From: Mike C. <mcheock_at_usc.edu>
Date: Thu, 09 Apr 1998 14:16:13 -0700
Message-ID: <352D3A9D.8635A4E5@usc.edu>


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?? Received on Thu Apr 09 1998 - 16:16:13 CDT

Original text of this message

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