Re: Truncate table - interaction with a long running query

From: "Alexander Fatkulin" <afatkulin@xxxxxxxxx>
To: peter.schauss@xxxxxxx
Date: Wed, 15 Aug 2007 16:24:58 -0400

If we are talking about read only query here.

The worst thing that could happen to you is "ORA-08103: object no
longer exists error" error (in the query session).

On 8/15/07, Schauss, Peter <peter.schauss@xxxxxxx> wrote:
> If one process attempts to truncate a table while another process is
> accessing it in a long running query, what happens?  (Oracle 8.1.7.4)
>
> Thanks,
> Peter Schauss
>
> --
> http://www.freelists.org/webpage/oracle-l
>
>
>


-- 
Alex Fatkulin,
The Pythian Group,
http://www.pythian.com/blogs/author/alexf/
--
http://www.freelists.org/webpage/oracle-l

References:

Truncate table - interaction with a long running query
From: Schauss, Peter

Re: Truncate table - interaction with a long running query

Other related posts: