Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Simple Oracle Query Taking Too Long
On Wed, 6 Sep 2006 15:01:06 -0700, "Bryan Hunter"
<bryan_at_exitexchange.com> wrote:
>The table in question is only being accessed by the procedure that is moving
>the data from that table to the other one. So there are no inserts or
>updates being performed on this table. So I assume since that since there
>is no data manipulation occuring that the data stays intact and that the
>select and delete get the same data.
>
Your assumption is false. The data *can* be accessed. You should *never* rely on assumptions like this, or you must be willing to become an expert in crap applications and have other developers and administrators suffer because of your applications.
-- Sybrand Bakker, Senior Oracle DBAReceived on Thu Sep 07 2006 - 00:04:03 CDT
![]() |
![]() |