Re: Help coalescing free space

--=-=-=__aa6kPFAhxd3Fl8Vpj7vMcLqDe__=-=-=

In article <344e96d4.4582877_at_newshost.interact.net.au>,

        granta_at_nospam.student.canberra.edu.au (Fuzzy) writes:
> Hi people,
>
> Once again I'm suffering from the joy of Oracle's space management
> techniques (or lack thereof). I've got a 7.1 database, with 700 Mb
> free, but cannot create a table with initial of 250M and next 100M
> because the freespace is fragmented. Is there a coalesce free space
> option in 7.1?
>
> Ciao
> Fuzzy

>:-)
>

Something picked up on the net a coupla years ago may help.

Tony

-- 
S. A. Sequeira tony_at_sequeira.powernet.co.uk
--=-=-=__aa6kPFAhxd3Fl8Vpj7vMcLqDe__=-=-=
Content-Type: application/octet-stream
Content-Disposition: attachment; filename="defrag.tar.gz"
Content-Transfer-Encoding: x-uue

begin 0644 defrag.tar.gz
<encoded_portion_removed>
end

--=-=-=__aa6kPFAhxd3Fl8Vpj7vMcLqDe__=-=-=--