a question about create table ?

From: Raymond Du <rdu_at_idmcorp.com>
Date: 19 Jun 1998 09:30:02 -0700
Message-ID: <6me3ma$p0i@nntp02.primenet.com>

  1 create table newtable as
  2* select county,state from orgtable
FULFILL>/
select county,state from orgtable

                         *

ERROR at line 2:
ORA-01658: unable to create INITIAL extent for segment in tablespace USERS

FULFILL>create table newtable as
  2 select * from orgtable
  3 TABLESPACE TABLESPACE_02;
TABLESPACE TABLESPACE_02
           *
ERROR at line 3:
ORA-00933: SQL command not properly ended

I want to create a table by using a select statement and using TABLESPACE_02 tablespace.

Thanks

Raymond Received on Fri Jun 19 1998 - 11:30:02 CDT