Re: creating a table from a table onto a non default tablespace

Hi Paul,

create table table1
TABLESPACE xyz
as select etc...

I agree you need to read the syntax diagram very carefully to know this is possible.
Hth,

Sybrand Bakker, Oracle DBA

paul <paul_at_www.internection.com> wrote in message news:k83dxr7etm.fsf_at_www.internection.com...
> Hi,
>
> I'm trying to find how to create a table from a table on a non default
> tablespace. Is this possible?
>
> For instance I can do:
>
> create table table1 (
> a number(1)
> ) tablespace tablespace1;
>
>
> and I can do
>
> create table table1 as select a from table2;
>
> but I can't figure out how to combine these two..
> I'm trying
>
> create table table1
> as select a from table2 tablespace tablespace1
>
> and I'm getting "SQL command not properly ended."
> Any suggestions?
>
> Thanks!
>
> paul
Received on Tue Aug 10 1999 - 12:15:52 CDT