Re: Packing or freeing datafiles?

From: Matthias Hoys <idmwarpzone_NOSPAM__at_yahoo.com>
Date: Wed, 4 May 2005 19:28:11 +0200
Message-ID: <4279062b$0$21876$ba620e4c_at_news.skynet.be>


<grz01_at_spray.se> wrote in message
news:1115225892.974577.199860_at_g14g2000cwa.googlegroups.com...
> Hi Steve,
>
> Yes, I know about those...
> that you can tell in what tablespace to rebuild the table.
>
> But it doesnt really give me control of in what DATAFILE
> or at what positions within a file to use for the rebuild,
> does it?
>
>

No. What you could is : create a new tablespace, do ALTER TABLE MOVE to move the tables to the new tablespace, then drop the old tablespace.

> stephen.how..._at_us.pwcglobal.com wrote:
>> Look up "alter table move" and "alter index rebuild" in the doco.
>> Regards,
>> Steve
>
Received on Wed May 04 2005 - 19:28:11 CEST

Original text of this message