If you are in 8.1, then you can create a dummy tablespace and issue the
command.
alter table <table1> move tablespace <dummy_ts>;
.
.
.
alter table <tablen> move tablespace <dummy_ts>;
alter table <table1> move tablespace <original_ts>;
.
.
.
alter table <tablen> move tablespace <original_ts>;
<table1> thru <tablen> are the tables that are in the fragmented tablespace.
<dummy_ts> is the dummy tablespace.
<original_ts> is the fragmented tablespace.
You also have two additional options available on these commands:
1) online after the move to move the table while it is online.
2) nologging
> -----Original Message-----
> From: Weerd de E.C. Kirsten [SMTP:Kirsten.deWeerd_at_Oranjewoud.nl]
> Sent: Wednesday, June 07, 2000 8:40 AM
> To: Multiple recipients of list ORACLE-L
> Subject: Datafiles - Free space
>
> Hi,
>
> Question :
>
> I have a couple of tablespaces with several datafiles. Within these
> tablespaces is quite a bit of free space, but scattered amongst the
> different files, thus unuseable for creating rather large tables. So I
> figured there must be a way to filter out the free space left unused and
> reuse it for an additional datafile or a resize of an existing datafile.
> Easiest would seem resizing the datafiles, freeing what's left of the
> space
> inside, but within the datafiles the free space is also scattered. I could
> see that in DBA_FREE_SPACE.
>
> Any hints as to how I can do this easily ?
>
> Greets,
>
>
> Kirsten
> --
> Author: Weerd de E.C. Kirsten
> INET: Kirsten.deWeerd_at_Oranjewoud.nl
>
> Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> San Diego, California -- Public Internet access / Mailing Lists
> --------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).
Received on Wed Jun 07 2000 - 18:11:47 CDT
