Re: How to change tablespace assigned to tables ?

From: Julio Negueruela <julio.negueruela_at_si.unirioja.es>
Date: Mon, 24 May 1999 16:00:43 +0200
Message-ID: <37495B8B.8F497969@si.unirioja.es>

Roby escribió:
> =

> I need to change the tablespace assigned to tables, but dropping the ta=
ble
> I loose contraints, indexes, and triggers.

You can export it, drop it and import it: 1.- Export the table and drop it.
2.- change the table owner's default tablespace and revoke him quotas in others tablespaces.
3.- Import the index creation commands to a text file (with the option indexfile of impot)
4.- Import the table but not the indexes. 5.- Change the user's default tablespace to the one where the indexes will be located and revoke quotas in the rest. 6.- Execute the file where the index creation commands were dumped to. 7.- Restore user's quotas and default tablespace.  =

> I have more the 150 tables then I want to know if there's another way t=
o do
> it.

 =

> Regards,
> =

> Roby
> =

> Roberto.Scanavino_at_rsisistemi.it

Hope this help.
-- =

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 24 1999 - 09:00:43 CDT