create table t
tablespace xyz
as
(select *
from table b);

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

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

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

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

Oracle LazyDBA home page