Thankyou. It is working.

Raja
> -----Original Message-----
> From: Michael Porter [SMTP:[Email Address Removed] Sent: Friday, June 29, 2001 2:42 PM
> To: LazyDBA.com Discussion
> Subject: Re: copying a table
>
> create table x tablespace whatever as select * from source_table;
>
> mike
>
> >>> Raja Ravipati <[Email Address Removed] 06/29/01 02:25PM >>>
> 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 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