Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Question about an article in the last Oracle Magazine
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