Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Updating by RowId when alread has fetched the row....

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

From: Daniel Morgan <damorgan_at_x.washington.edu>
Date: Mon, 08 Mar 2004 12:51:25 -0800
Message-ID: <1078779050.694684@yasure>


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)
Received on Mon Mar 08 2004 - 14:51:25 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US