Re: Tablespaces

From: Jan Gelbrich <j_gelbrich_at_westfalen-blatt.de>
Date: Wed, 9 Oct 2002 12:21:39 +0200
Message-ID: <ao1062$i4l71$1@ID-152732.news.dfncis.de>

try

ALTER TABLE mytable
MOVE
TABLESPACE new_ts_name

Caution ! In some cases, indexes on moved tables become invalid (check dba_indexes for them).
In that case, You would have to rebuild them.

And if You still have DMTs, use an appropriate storage clause, too.

Hope it helps,
Jan

"s Lehaire" <s.lehaire_at_meilleuregestion.com> schrieb im Newsbeitrag 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:21:39 CDT