Re: How long would data last in Rollback Segment?

From: <pberetta_at_my-deja.com>
Date: Mon, 06 Dec 1999 11:13:28 GMT
Message-ID: <82g5on$526$1@nnrp1.deja.com>

Allas,
  The data stays in the rollback segment until

1. You issue an explicit COMMIT; or ROLLBACK;
2. An implicit commit is issued by exiting the session
3. An implicit rollback is issued by the session terminating abnormally

  As for a good book I like Richard Barker's 'CASE*Method Entity Relationship Modelling', published by Addisson Wesley/Oracle Press. Even if you do not use CASE tools, it will help with the general concepts of relational database design. Hope this helps,
Paul

In article <82g1ae$25n$1_at_nnrp1.deja.com>,   allasrosa_at_hotmail.com wrote:
> Hi,
>
> I'm quite a newbie to oracle.
>
> 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?
>
> 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.
>

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Mon Dec 06 1999 - 05:13:28 CST