Re: Updating by RowId when alread has fetched the row....

srivenu wrote:

> Theoritically my example may not make sense.
> But practically, I have seen some DBA's reorg tables in production
> databases while the system was up and running normally.
> regards
> Srivenu

I do it all the time using DBMS_REDEFINITION. But storing of rowid's in a table is a practice built on a foundation of quick sand. It doesn't take a reorg to make the data worthless ... only an update or a delete.

-- 
Daniel Morgan
http://www.outreach.washington.edu/ext/certificates/oad/oad_crs.asp
http://www.outreach.washington.edu/ext/certificates/aoa/aoa_crs.asp
damorgan_at_x.washington.edu
(replace 'x' with a 'u' to reply)