Re: About my latest Question (lock temp table)

I think we just did this one, but here goes; the syntax should probably be: > create temp table tt > (aa any_type) WITH NO LOG; unless you would like to be able to rollback work on the temp table itself. But there is still no reason to lock a temp table because (someone please tell me if i'm wrong) the process that creates the table is the only one which can reference it, making locks irrelevant. -- Sincerly, Doug Wilson(dougw@amgen.com) *** The opinions expressed here are my own and not neccessarily *** *** anyone elses **** *** Disclaimer: These are the opinions of the poster not Amgen Inc.***