question on temporary table

From: <luio_at_my-deja.com>
Date: Tue, 22 Aug 2000 15:52:13 GMT
Message-ID: <8nu7j2$mbf$1@nnrp1.deja.com>

I got a problem on the limit of global temporary table. Looks like there is some limit like size, transaction or ... on temp table.

I cannot do too many operation on the temp table, but if I change it to a normal table, it will works perfectly. I need a temp table in my program. how can I change the properties of a temp table?

is global temporary table different for each connection session? Is there any table is only related to one session?

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Tue Aug 22 2000 - 10:52:13 CDT