Peter,
When a temporary table is created, a dictionary definition of the table
is also created.
Space is
not actually allocated for the table until it is populated
GTT tables are not
dropped when a session or transaction ends, the session specific data is only
deleted (truncated)
The
table definition still exists and temporary segments are cleaned up.
Regards
Suhen
Hi
I
am working on some development here and have decided to use temporary tables to
do some work as they seemed to be the best way to acheive what I wanted and the
data is only required for the sesion.
I
seem to be experiencing a problem where the only way the temporary tables are
removed is by actually dropping them or by bouncing the database.
I
thought that they were supposed to be session specific or program module
specific.
Perhaps
I misundestood the docs
I
am creating them as follows
v_CreateString
:= 'CREATE GLOBAL TEMPORARY TABLE t_tmp_cal1 ( part NUMBER, readings NUMBER) ON
COMMIT PRESERVE ROWS';
EXECUTE
IMMEDIATE v_CreateString;
and
v_CreateString
:= 'CREATE GLOBAL TEMPORARY TABLE t_tmp_cal2 ( part NUMBER) ON COMMIT DELETE
ROWS';
EXECUTE
IMMEDIATE v_CreateString;
Oracle8i
Enterprise Edition Release 8.1.7.0.0 - Production
I have looked at metalink and found nothing specific to point the way
Any
help appreciated
--
=================================================
Peter McLarty E-mail:
[EMAIL PROTECTED]
Technical Consultant WWW: http://www.mincom.com
APAC Technical Services Phone: +61 (0)7 3303 3461
Brisbane, Australia Mobile: +61 (0)402 094
238
Facsimile: +61 (0)7 3303 3048
=================================================
A great pleasure in life is doing what people say you cannot do.
- Walter Bagehot (1826-1877 British Economist)
=================================================
Mincom "The People, The Experience, The Vision"
=================================================
|
|
--
This transmission is for the intended addressee only
and is confidential information. If you have received this transmission in
error, please delete it and notify the sender. The contents of this e-mail are
the opinion of the writer only and are not endorsed by the Mincom Group of
companies unless expressly stated otherwise.