Re: Tablespaces

Assuming you are using oracle 8i or 9i and the table doesn't have any LONG or LONG Raw fields you can use

alter table move mytable NEWTABLESPACE;

Note if the table has any indexes you will need to rebuild them after the move.
(Check the SQL REF guide for the complete syntax)

Stephen C. Ashmore
Brainbench MVP for Oracle Administration http://www.brainbench.com

Author of: 'So You Want to be an Oracle DBA?'

"s Lehaire" <s.lehaire_at_meilleuregestion.com> wrote in message news:ao0tb7$p3p$1_at_reader1.imaginet.fr...
> Hi,
> How can I move a table on a new tablespace ?
> I know that I can move a index on an other tablespace with this command :
> alter index MYINDX rebuild tablespace MYTABLESPACE.
>
> I have some tables on the tablespace system and I want to move them on my
> tablespace.
> To day for that I use a borring method:
> Create the same table with a new name
> copy the data from the old to the new, drop the old and rename the new
with
> the old name (is my indexes are ok after this?).
> So if there's a method like the alter index command it would be great.
>
> Thx for helping me
>
>
>
>
>
Received on Wed Oct 09 2002 - 05:33:46 CDT