can you give me syntax. Thankyou.

Raja

> -----Original Message-----
> From: Thurow, Laura [SMTP:[Email Address Removed] Sent: Friday, June 29, 2001 2:37 PM
> To: LazyDBA.com Discussion
> Subject: RE: copying a table
>
> 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 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