Re: help:move object within the tablespace

From: Daniel A. Morgan <Daniel.Morgan_at_attws.com>
Date: Fri, 22 Jun 2001 13:03:43 -0700
Message-ID: <3B33A49F.F8FB066B@attws.com>

u518615722_at_spawnkill.ip-mobilphone.net wrote:

> Hi,
>
> In our "USERS" tablespace we have several datafiles, is it possible that
> we move the objects in one datafile to another datafile within the
> same tablespace, so that we can resize one or two of the datafiles to
> reclaim the space?
>
> Thanks for your help
>
>
> --
> Sent by dbadba62 from hotmail piece from com
> This is a spam protected message. Please answer with reference header.
> Posted via http://www.usenet-replayer.com/cgi/content/new

No.

Export the objects. Verify your export if valid. Then drop and recreate the tablespace.

Daniel A. Morgan Received on Fri Jun 22 2001 - 15:03:43 CDT