Home » RDBMS Server » Server Administration » processing of a DELETE or INSERT command
processing of a DELETE or INSERT command [message #60813] Mon, 08 March 2004 16:54 Go to next message
cuihh6
Messages: 12
Registered: February 2004
Junior Member
In oracle's "Enterprise DBA Part 1A : Architecture and Administration" vol.1 page 1-20

The processing of a DELETE or INSERT command uses similar steps. The before-image
for a DELETE contains the column values in the deleted row, and the before-image
of an INSERT contains the row location information.

What can be called row location information ?

Report message to a moderator

Re: processing of a DELETE or INSERT command [message #60834 is a reply to message #60813] Tue, 09 March 2004 09:29 Go to previous message
ilver
Messages: 50
Registered: January 2004
Member
The ROWID psuedo-column describe the physical location / storage information related to a row.

Both DELETE and INSERT have to deal with that.

So my guess is that "row location information" mean ROWID value.

/ilver

Report message to a moderator

Previous Topic: corrupted blocks
Next Topic: Snapshot Error on oracle 9i Auto Undo Management
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Fri Sep 20 12:41:54 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.