Re: To make a copy of a table

the order in an oracle table is not guaranteed but ei had the same problem and the following workaround worked:

1. i attatched th table to access and exported all data to access.
2. i truncated the oracle table
3. i wrote the data back using an access query with an order by.

on the server i used the data were in the right order after that. (but its not guaranteed)

olaf

On Thu, 8 Jan 1998 14:29:03 -0500, BradMurray_at_SeeSignatureIfThere.com (Brad Murray) wrote:

>In article <693393$5i6$1_at_naiad.grenet.fr>, cicg_at_cicg-
>communication.grenet.fr said...
>> I want to make a copy of a table in alphabetical order.
>> I tried to do this:
>> create table T2 as select * from T1 order by colX;
>> This does not work...
>
>This is a table. The order of the rows is not really important. If you
>need the new table to be ordered for subsequent queries you will need to
>put an order by clause in those queries. Oracle doesn't allow you to put
>an order by clause in a create table as statement for this reason.
>
>Think about it this way. You create your table this way so that you don't
>have to order it in future use. Then somebody adds a row. It will
>probably now be out of order.
>_______________________________________________________________________
> Bradley S. Murray Princeton Computer Consulting (609) 730-9100
> BradMurray(-at-)usa.net Pennington, NJ 08534-3612 Fax: 275-5651
Received on Fri Jan 09 1998 - 00:00:00 CST