Re: ORA-01654 Error Handling

From: beerora <beersa.beersa_at_gmail.com>
Date: 13 Sep 2006 19:01:53 -0700
Message-ID: <1158199313.667727.162220@e63g2000cwd.googlegroups.com>

Hi All,

Thx for the replies.

Mr. Fitzjarrell, your guidance is very helpfull. Thank you for valuable information.

Cheers,

fitzjarrell_at_cox.net wrote:
>
> This table you deleted from is not the ONLY table using this index
> tablespace; you have no space, or the space you DO have remaining isn't
> contiguous or it isn't of sufficient size to allow this index to
> extend. Or the free space you do have hasn't been coalesced. You
> could query dba_free_space for the 'offending' tablespace to see what
> is available, but the simplest solution is to add space to the
> tablespace.
>
> No one can tell you what conditions you have which cause this error to
> occur; you haven't provided enough information to do that.
>
>
> David Fitzjarrell
Received on Wed Sep 13 2006 - 21:01:53 CDT