How long would data last in Rollback Segment?

From: <allasrosa_at_hotmail.com>
Date: Mon, 06 Dec 1999 09:57:35 GMT
Message-ID: <82g1ae$25n$1_at_nnrp1.deja.com>

Hi,

[Quoted] I'm quite a newbie to oracle.

[Quoted] I know that the Rollback Segment keeps data that's ready to commit to the database. But what will happen if I just insert or update a row without committing it? Will the uncommitted row stay in the rollback segment forever? If not, for how long will it stay there?

[Quoted] Btw, can anyone suggest websites / books that talk about the how to work well with Oracle database stucture. And points to bare in mind when designing a database system?

Many thanx!

Rgds,
Allas

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Mon Dec 06 1999 - 10:57:35 CET

This message: [ Message body ]
Next message: Lindsay Walker: "Re: ora-03121"
Previous message: Karl R.: "Missing Bitmaps with Developer Foms Server 6.x and OAS 4.0.7"
Next in thread: pberetta_at_my-deja.com: "Re: How long would data last in Rollback Segment?"
Reply: pberetta_at_my-deja.com: "Re: How long would data last in Rollback Segment?"
Reply: Thomas Kyte: "Re: How long would data last in Rollback Segment?"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message