Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Two "create table as select" locking?

Two "create table as select" locking?

From: Greg Simpson <ABCNOSPAMgsimpson_at_ecodev.com>
Date: Thu, 23 Aug 2001 07:43:05 -0500
Message-ID: <rT6h7.92$Bt4.68890@newsfeed.slurp.net>


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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US