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

Home -> Community -> Usenet -> c.d.o.server -> Question about an article in the last Oracle Magazine

Question about an article in the last Oracle Magazine

From: Francesco Dini <dini.f_at_adr.it>
Date: Fri, 11 Feb 2000 14:50:43 +0100
Message-ID: <38A413B3.33E2147B@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

Thanks in advance
Francesco Received on Fri Feb 11 2000 - 07:50:43 CST

Original text of this message

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