Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Two "create table as select" locking?
Recently, a fellow DBA ran into a situation where two users issued a "create
table as select * from A" at the exact same time. Neither job returned after
an hour. She killed one of the jobs and the other finished immediately.
Question: did the two "create table as select * from A" commands lock each
other out? I know two "select * from A" should never lock each other, but
does the "create table as" request a different type of lock?
Thanks,
Greg
Received on Thu Aug 23 2001 - 07:43:05 CDT