Re: Tablespaces

From: Matthias Rogel <m.rogel_at_market-maker.de>
Date: Wed, 9 Oct 2002 12:06:30 +0200
Message-ID: <ao0v38$h0kbi$1@ID-86071.news.dfncis.de>

hi,

being a DBA *IS* boring.
your approach is the right one (don't forget to build all indexes again)

matthias

"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:06:30 CDT