Re: question on temporary table

Are you choosing:

    on commit delete rows
or

    on commit preserve rows

There is, in theory, no strange limit
on temporary tables, although the
space allocated is in the current
user's temporary tablespace, and
therefore you may hit the usual
'unable to allocate' problem.

Each connection gets its own physical
instantiation of the temporary table definition, in its own segment - another reason why you can rapidly run out of temporary tablespace.

--

Jonathan Lewis
Yet another Oracle-related web site:  http://www.jlcomp.demon.co.uk

luio_at_my-deja.com wrote in message <8nu7j2$mbf$1_at_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.