Re: Moving tables/indexes from one tablespace to another

From: Giovanni Cuccu <giovanni.cuccu_at_gmail.com>
Date: Tue, 14 Jun 2005 10:12:26 +0200
Message-ID: <23e0d1170506140112a328a6@mail.gmail.com>

Hi John,

   if you are using oracle 8i or newer you can try alter table move.... command
don't forget to rebuild indexes with
alter index rebuild.... comand
since moving a table implies rowid change and this invalidates all indexes on it.
Hope it helps,

    Giovanni

On 6/14/05, John Dunn <jdunn_at_sefas.com> wrote:
> Is there any easy way to move tables and indexes from one tablespace to
> another, other than dropping and recreateing?

>=20

> John

>=20

> John Dunn
> Product Consultant
> Sefas Innovation Limited
> Direct Dial + 44 (0) 117 915 4267
> www.sefas.com

>=20

> PLEASE NOTE SEFAS INNOVATION ARE MOVING THURSDAY 23rd JUNE 2005 TO:
> Sefas Innovation Ltd, CityPoint, Temple Gate, Bristol BS1 6PL, UK.
> Tel: +44(0) 117 373 6114
> Fax: +44 (0) 117 373 6115
> NEW DIRECT DIAL: +44 (0) 117 373 6122

>=20
>=20

> --
> http://www.freelists.org/webpage/oracle-l
>=20

--=20

---

Another free oracle resource profiler
http://sourceforge.net/projects/oraresprof/ New version 0.8 with many bug fixes
and warnings on file truncated, timed_statistics=3Dfalse, incorrect tracing deactivation and more

--
http://www.freelists.org/webpage/oracle-l

Received on Tue Jun 14 2005 - 04:17:34 CDT