Re: Moving tables/indexes from one tablespace to another
- From: Giovanni Cuccu <giovanni.cuccu@xxxxxxxxx>
- To: jdunn@xxxxxxxxx
- Date: Tue, 14 Jun 2005 10:12:26 +0200
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@xxxxxxxxx> 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
> --
> //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
--
//www.freelists.org/webpage/oracle-l
Other related posts:
