Re: About my latest Question (lock temp table)

It could run out of system locks. Depends on the level of locking you use, Number of rows being inserted and the max number of locks defined in the configuration file for you "ONLINE" DB. ------------------------------------------------------------------------- Cheryl Kendricks Internet:cherylk@prod1.jcdc.doleta.gov OR cherylk@gwysmtp.jcdc.doleta.gov DTSI, Inc. Database Administrator - DOL Job Corps San Marcos, Texas ------------------------------------------------------------------------ On Thu, 26 Sep 1996, Manel Falco wrote: } } I expose this example about my lastest question: } } create temp table tt } (aa any_type); } begin work; } } lock table tt in share mode; { Is necessary this lock. ??? } } } { Might it run out of system locks ??? } } } insert into tt { !!!! } } select any_value from any_big_table; } commit work; } } } } }