Re: Two "create table as select" locking?

From: Anatoly Moskovsky <avm_at_trais.com.ua>
Date: Fri, 24 Aug 2001 14:02:32 +0300
Message-ID: <TRS10625D401@trais.com.ua>

Hi!

• On august 23 Greg Simpson wrote:

 GS> Thanks for the info, but I don't think this is the same situation.

Now I see. Sorry, from your first posting I understood that the queries were exactly the same.

I think it was a bug.
Try this:

SQL1> create table X as select * from A where rownum < 1;
SQL2> create table Y as select * from A where rownum < 1;
SQL1> insert into X select * from A;
SQL2> insert into Y select * from A;
SQL1> commit;
SQL2> commit;

Is the result the same? If is, on which step the blocking occurs?

Bye

---

Anatoly Moskovsky, Oracle Developer avm_at_sqlbatch.com [SQL Batch/Oracle, DBA tools, reverse engineering, scripting extensions]: http://sqlbatch.com/sb/ Received on Fri Aug 24 2001 - 06:02:32 CDT