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_at_si.unirioja.es>
Date: Mon, 31 May 1999 16:18:07 +0200
Message-ID: <37529A1F.BDD42248_at_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 to
> 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.esReceived on Mon May 31 1999 - 16:18:07 CEST