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 LazyDBA home page