Thankyou all for the reply. It worked.

Raja

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