Re: contiguous space??

Look up Alter Tablespace Coalesce.

<gdas_at_my-deja.com> wrote in message news:91o7uh$7bh$1_at_nnrp1.deja.com...
> Today, our app reported that a tablespace could not be extended...
>
> The tablespace has almost 1 Gig free (according to dba_free_space).
> And the next_extent for the object it was trying to extend which
> reported the error (in this case an index) was 250 MB. The maxentents
> had not yet been reached on the object.
>
> So, I'm wondering if this problem is being caused due to a lack of
> contiguos space on the Hard Drive? Or could it be because of something
> else. If it is due to lack of contiguous space, is there anyway to
> unfragment things (aside from recreating and reimporting the database)?
> I've tried coalescing the tablespaces and that didn't seem to help.
>
> Also, an aside question perhaps related... If the maxextents on a
> tablespace is 121 yet the maxextents on an object in that tablespace is
> 256, does that present a problem? Do the storage properties of a
> tablespace have any meaning other than simply being default values for
> the objects in that tablespace?
>
> Thanks for any advice.
> Gavin
>
>
>
> Sent via Deja.com
> http://www.deja.com/
Received on Wed Dec 20 2000 - 15:27:23 CST