Defragment tablepace program for Oracle v6
From: Amit Srivastava <amit_at_MCS.COM>
Date: 1995/07/31
Message-ID: <3vjn7u$l65_at_Mars.mcs.com>#1/1
Date: 1995/07/31
Message-ID: <3vjn7u$l65_at_Mars.mcs.com>#1/1
Hi,
I am trying to write a defragmentation program (using perl)
for Oracle v6. Basically, I am looking at the table dba_free_space and
getting the blocks listed in it, sorted by block order.
Then I look at the largest contigous size block space available, by
connecting adjacent blocks.
I then, go about creating temp. tables in desc avail space order.
However, after creating the first table I get the ORA-6004 error occured at recursive SQL Level.
Theoretically, I think, after creating the tables I would just go about dropping them. And I would have all my largest cont. blocks.
BUT I don't know what I could be doing wrong?
-- _/_ __. ____ o / (_/|_/ / /_<_<__ |address:amit_at_mcs.com|Received on Mon Jul 31 1995 - 00:00:00 CEST