Re: RELOCATE TABLES FROM ONE TABLESPACE TO ANOTHER ONE ?

From: Julio Negueruela <julio.negueruela_at_si.unirioja.es>
Date: Mon, 31 May 1999 16:18:07 +0200
Message-ID: <37529A1F.BDD42248@si.unirioja.es>

=?iso-8859-1?Q?Jo=EBl?= Dessart escribió:
> =

> I want to know if it's possible to change a table from one tablespace
> to another one without using drop and create command.
> I have a lot of tables in a bad tablespace so if it exist an easy way t=
o
> do so...
> Thank you,

I'm afraid that the only way to do it is exporting/importing the table. You can export it, drop it, recreate it in the new tablespace and import it with the option ignore=y

Regards.
-- =

Julio Negueruela
DBA Servicio Informático

Universidad de La Rioja      -      Spain
Telf: 941-299179     Fax: 941- 299180

mailto:julio.negueruela_at_si.unirioja.es Received on Mon May 31 1999 - 09:18:07 CDT