Sorry for the confusion specify the tablespace in your syntax

-----Original Message-----
From: Raja Ravipati [mailto:[Email Address Removed] Friday, June 29, 2001 2:32 PM
To: 'Lages, Carl'; Raja Ravipati; LazyDBA.com Discussion
Subject: RE: copying a table


This will create the table in the default tablespace. I wanted it to be
created into a new tablespace.

Raja

> -----Original Message-----
> From: Lages, Carl [SMTP:[Email Address Removed] Sent: Friday, June 29, 2001 2:46 PM
> To: 'Raja Ravipati'; LazyDBA.com Discussion
> Subject: RE: copying a table
>
> create schema.table_a
> as select * from schema.table_b
>
> -----Original Message-----
> From: Raja Ravipati [mailto:[Email Address Removed] Sent: Friday, June 29, 2001 2:26 PM
> To: LazyDBA.com Discussion
> Subject: copying a table
>
>
> Hi DBAs,
>
> How can we copy a table into a different tablespace?
>
> Thankyou.
>
> Raja
>
> --------
> Oracle documentation is here:
> http://tahiti.oracle.com/pls/tahiti/tahiti.homepage
> To unsubscribe: send a blank email to oracledba-[Email Address Removed] To subscribe: send a blank email to oracledba-[Email Address Removed] Visit the list archive: http://www.LAZYDBA.com/odbareadmail.pl
> Tell yer mates about http://www.farAwayJobs.com
> By using this list you agree to these
> terms:http://www.lazydba.com/legal.html
Oracle LazyDBA home page