Create table as ...

From: Wei Tang <wtang_at_cs.ualberta.ca>
Date: 1998/01/17
Message-ID: <69ovpt$qdj$1@scapa.cs.ualberta.ca>#1/1

Hi, there:

I wonder if anyone of you ever used "create table as subquery" statement to create a table.

I have a table called test:
create table test(

	name	varchar2(10),
	ID	number);

But I cannot use the following statement: create table test_bak as select * from test order by ID;

It said: ORA-00933: SQL command not properly ended.

When I remove the "order by" clause, everything is fine. I couldn't find any documentation saying "order by" is not supported in "create table as..." statement.

What's wrong with that?

I need your expertise in a rush. Please help me.

Thanks. Received on Sat Jan 17 1998 - 00:00:00 CST