Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Two "create table as select" locking?
Greg,
I don't think this is a table locking issue. Might be because table A is pretty big which is the reason. Using NOLOGGING will speeden up the table creation.
create table X NOLOGGING as select * from table A where ...; create table Y NOLOGGING as select * from table B where ...;
Anurag
"Greg Simpson" <ABCNOSPAMgsimpson_at_ecodev.com> wrote in message news:<Koch7.13$nS4.8533_at_newsfeed.slurp.net>...
> Thanks for the info, but I don't think this is the same situation. One user
> would be running:
>
> user1> create table X as select * from table A where ....;
>
> and the other:
>
> user2> create table Y as select * from A where ....;
>
> The 'WHERE' clauses are similar and may be generating the same plan (didn't
> look), but by the time Oracle is at the 'SELECT' part of the procedure, what
> would be locking table A?
>
> The X and Y tables are being created in the same tablespace. Would the
> CREATE step be getting locks on the data dictionary?
>
> Thanks,
> Greg
>
Received on Thu Aug 23 2001 - 18:31:42 CDT