Re: Truncate table - interaction with a long running query

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_at_ngc.com> 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