Re: Please help on rollback segments!

From the manual,

ORA-00604 is :-

<QUOTE>

ORA-00604: error occurred at recursive SQL level num

Cause: An error occurred while processing a recursive SQL statement. A recursive SQL statement is one that applies to internal dictionary tables.

Action: If the situation described in the next message on the stack can be corrected, do so; otherwise, contact customer support.

<UNQUOTE>

Doesn't sound to me like a simple rollback segment issue at all.

David P.

jian354_at_my-deja.com wrote:
>
> Today I found that the rollback tablespace and segments were almost
> full in my oracle server (7.3.4 under NT), which always brings back the
> error ORA-00604 for my application. I tried to kill all the sessions
> and hoped that system will free and collect those occupied rollback
> space, but it didn't work. I also tried to add more data files to the
> tablespace, and it didn't do any good for my application either.
> Does anyone know how I can manually clean up those spaces (about 400M)?
> None of the tables or indexes uses that space. It is just weird how
> those spaces haven't been released.
> Any suggestion will be greatly appreciated!
> Thanks.
> --Jian
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
Received on Thu Mar 16 2000 - 00:00:00 CST