1. Create table as select into new tablespace as new_table.
2. Drop original table
3. Rename new_table to original table name

OR

Export/Import

> -----Original Message-----
> From: Raja Ravipati [SMTP:[Email Address Removed] Sent: Friday, June 29, 2001 1: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
>

"WorldSecure" made the following
annotations on 06/29/01 13:35:07
------------------------------------------------------------------------------

[INFO] -- Virus Manager:
This message was scanned with Network Associates Viper,
and no viruses were detected.

==============================================================================

Oracle LazyDBA home page