Re: Question about an article in the last Oracle Magazine

This statement works in 7.3.4+
and in 8.1, but not in 8.0

Congratulations for listing the version banners - perhaps the rest of us
should follow your lead more often.

--

Jonathan Lewis
Yet another Oracle-related web site: http://www.jlcomp.demon.co.uk

Francesco Dini wrote in message <38A413B3.33E2147B_at_adr.it>...
>Hello everybody,
>I read an article in the last Oracle Magazine (January/February 2000)
>about tuning tables (page 109-114) and I try to follow the example 1.
>But I noted that the statement create table new_table_name as select *
>from old_table_name order by index_name isn't correct. It gave me the
>ora-0933 error regarding the use of the order by in the create table or
>view.
>Could somebody tell me something about it?
>
>This is my database version:
>
> Oracle8 Enterprise Edition Release 8.0.5.0.0 - Production
> PL/SQL Release 8.0.5.0.0 - Production
> CORE Version 4.0.5.0.0 - Production
> TNS for IBM/AIX RISC System/6000: Version 8.0.5.0.0 - Production
> NLSRTL Version 3.3.2.0.0 - Production
>
Received on Fri Feb 11 2000 - 09:45:38 CST