View Single Post
  #3 (permalink)  
Old October 12th, 2004, 11:12 PM
combo combo is offline
Registered User
 
Join Date: Sep 2004
Location: , , .
Posts: 5
Thanks: 0
Thanked 0 Times in 0 Posts
Default

Hey Justin,
    Yes, this will be done on a production database. I will the have weekend to handle this. I believe it is a locally managed. The free space coalesced was at 88%. My real problem is an ora 1653 'UNABLE TO EXTEND TABLE' error where I could not insert into a table. The PCT_INCREASE was at 25 and the next_extext was at 160mb. Way too large. There still looks to be l plenty of space available for an another extent but it is not being allocated.