Re: How to create a second table as sorted on one column of first table?

Hi!

Maxim V. Krapivin wrote:
>
> David Shi wrote :
> >I tried:
> > create table second as select * from first order by key;

Try to export ordered data using SQL*Plus and import using SQL*Loader.

> >but didn't work. Any help is greatly appreciated!
> >David
>
> All right. The data in any table is unsorted. You can use ORDER BY clause
> when fetching data from the table. But when you create one table from
> another this means nothing.

In fact rows ARE ordered. You can read about it at http://www.oramag.com/archives/27/27DBA.html (march/april 1997, "How healthy is your index?").

--

Wladislav Ovchinnikov, DBA
Donetskaya direktsiya Ukrsotsbanka
Donetsk, Ukraine

e-mail: wlad_at_cbsd.donetsk.ua Received on Wed May 20 1998 - 03:12:12 CDT