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

>Create Table table1 Tablespace tablespace1 as select a from table2;
would do it.

-Thiru

paul wrote:

> 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:37:45 CDT