Xref: alice comp.databases.oracle.server:33529
Path: alice!news-feed.fnsi.net!news.idt.net!newsfeed1.swip.net!swipnet!news.tele2.nl!newsgate.cistron.nl!het.net!pascal.a2000.nl!not-for-mail
From: pantah@commonsense.speed.a2000.nl (Jan Dolman)
Newsgroups: comp.databases.oracle.server
Subject: Re: Move table to another tablespace
Date: Wed, 11 Nov 1998 17:56:53 GMT
Organization: No, it's personal
Lines: 25
Message-ID: <3649cf07.2980078@news.a2000.nl>
References: <364762e6.231624@news.a2000.nl> <36476C10.E4DDDF06@sybrandb.demon.nl>
Mime-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
X-Newsreader: Forte Agent 1.5/32.452

On Mon, 09 Nov 1998 23:26:24 +0100, Sybrand Bakker
<postbus@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@commonsense.speed.a2000.nl
(remove "commonsense." when replying)