About all you can do is something like create a table with a slightly
different name from the original. You could simply do CREATE TABLE
newtable AS SELECT * FROM oldtable. Since you've changed the default
tablespace for the user, the new table will be created in the new
tablespace. Once done, just drop the original table and rename the new
table to the original table name.
> -----Original Message-----
> From: Dr. Jan Dieckmann [SMTP:JDieckmann_at_psi.de]
> Posted At: Tuesday, March 16, 1999 10:47 AM
> Posted To: comp.databases.oracle.server
> Conversation: tables
> Subject: Re: tables
>
> Hi,
>
> you can move an index with the command REBUILD but as far as I know
> you can
> not move the table.
>
> regards Jan Dieckmann
>
> naveen_arora_at_my-dejanews.com wrote:
>
> > hi,
> > i initially created tables from a user account with tablespace A
> > i now have changed the default tablespace of user to B
> > is there any way to move the extends and data from tablespace A to B
> ?
> > thanks for any help
> > naveen_at_cdotd.ernet.in
> >
> > -----------== Posted via Deja News, The Discussion Network
> ==----------
> > http://www.dejanews.com/ Search, Read, Discuss, or Start Your
> Own
>
>
Received on Tue Mar 16 1999 - 10:25:21 CST
