Re: Errror ORA-1595

From: <satar_at_my-dejanews.com>
Date: Tue, 08 Dec 1998 19:53:44 GMT
Message-ID: <74k047$cr4$1@nnrp1.dejanews.com>

It's not a serious problem. After the user commits or rollsback, the rollback segment will return to its optimal size. Anyway...here's what the documentation says: ORA-01595 error freeing extent num of rollback segment name

Cause: An error occurred while freeing inactive rollback segment extents.

Action: Check the trace file and check for prior messages.

Not much help, is it?

-Satar

In article <366D4E58.4A5B_at_ccschaper.de>, zierke_at_ccschaper.de wrote:
> Hi,
>
> we have one seriouse problem: Our rollback segment is full. We tried to
> say "alter rollback segment rbs1 shrink to 5M;", but the server said
> "error freeing extent <293> of rollback segment rbs1".
>
> Where is the solution ?
>
> Much thanks for answers.
>
> Martin
> --
> C+C Schaper GmbH
> Eckener Str. 2
> D-30179 Hannover
>

--
Oracle DBA/UNIX System Admin
Advanced Enterprise Solutions
(949) 756-0588
Oracle Re-Seller

-----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own Received on Tue Dec 08 1998 - 13:53:44 CST