Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Packing or freeing datafiles?
<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 - 12:28:11 CDT