Re: Move table to another tablespace

From: Jan Dolman <pantah_at_commonsense.speed.a2000.nl>
Date: Wed, 11 Nov 1998 17:56:53 GMT
Message-ID: <3649cf07.2980078@news.a2000.nl>

On Mon, 09 Nov 1998 23:26:24 +0100, Sybrand Bakker <postbus_at_sybrandb.demon.nl> wrote:

>Hi Jan,
>If this is the only table that needs to be reorganized, yes it is.
>Otherwise export the user, change his default tablespace and make sure
>he doesn't have quota on the original tablespace. Now import the data
>and tables will automatically end up in the new tablespace.
>
>Hth,
>
>Sybrand Bakker, Oracle DBA
>

Thanks for that.

Today I accidently stumbled across a solution in the Oracle Enterprise Manager (the Tablespace Manager, I think it is part of the Performance Pack). It incluses a method to automate the export & import, including indexes (it just didn't work on my PC, have to sort that out first).

Jan

pantah_at_commonsense.speed.a2000.nl
(remove "commonsense." when replying) Received on Wed Nov 11 1998 - 11:56:53 CST