Global Temporary Table
I would like to know if i am doing the right thing or not??
I've created a global temporary table "tempcomp".
"create global temporary table tempcomp (col1 number,col2
I looked into these groups and it was mentioned somewhere
that default is "on commit delete rows"... I am assuming that the rows
are being deleted after commit and not stored .
We have a web application which would be calling a stored
procedure which inserts into a global temporary some values we nee...Global Temporary Tables
Am wanting to create a temporary table within a PLSQL package. Have
EXECUTE IMMEDIATE 'create global temporary table temp_status........'
Problem now is that package wont compile due to insert statements for
this table. Compiler has no idea about this temp table or its
I take it temporary tables arent designed for this use are am i
missing something here?
Roy Munson wrote:
> Am wanting to create a temporary table within a PLSQL package. Have
> EXECUTE IMMEDIATE 'create global temporary table temp_status.........Global temporary table
I dont know how to declare and use a global temporary table in my java
I used these statements:
sql="declare global temporary table
session.temp(recordinteger,eventtype character(20)) not logged";
For inserting I'm trying to do..
sql="insert into session.temp values(2003,'fatal error');
But its flagging an error.With just the declare statement there is no
error.But i read somewhere that a temporary table space needs to be
created.I dont kn...global temporary tables?
In our application we have a table that tracks network sessions. The
1) create a session record
2) read/update the record several times during the session
3) delete the session record when the session ends
Update activity on this table is going to be pretty intense, and the
transient nature of the data makes it a good candidate for a temporary
and/or in-memory table.
Unfortunately, different network connections may be updating the same
session record at different times (connection pool), so the CREATE TABLE
TEMPORARY doesn't seem to fit the bill, since i...Global Temporary Tables
I am inserting records to a global temporary table(say A) in which a
trigger is fired and im getting results from other global tempory
tables(say B, C, D,..)...
This is my scenario...
I am able to fetch the results from the global temporary tables
B,C,D,...when inserting directly in the table A from the front end.
But I am not able to fetch the results from the global temporary
tables B,C,D,...when inserting thru a web service (in dotnet)in the
table A from the front end.
Can somebody explain the reson for the above and give a solution to
fetch the records from the global ...Global temporary table and SP
I'm using SS2K on W2K.
Brieffing: Many months ago, I created a stored procedure only used by those
with admin rights in SS. Now, someone else (without admin rights) has to run
it. I gave him rigth to execute the SP but, at the second and more
execution, he got a error message concerning a temp table already existing
CREATE PROCEDURE MySP
DECLARE @strSQL AS VARCHAR(4000)
IF EXISTS (SELECT table_name FROM tempdb.information_Schema.tables WHERE
table_name = '##MyTmpTable...Global Temporary Table #2
We are running on Oracle 18.104.22.168 on Unix (AIX 22.214.171.124)
I'm facing a problem with a global temporary table (on commit preserve
rows) : it is going through the loop :
- delete all
At the beginning of the procedure everything is going fine. I can see
how the process is going on in v$session.
After half an hour, the speed begins to decrease a lot and there are
lot of "db file scattered read" events pointing to my temporary table.
It is true that there are lots of FTS on this temporary table, but its
content is very small (about 20 rows at each step of t...Load global temporary table
I have a fixedwidth .DAT file and a DB2 table, I have to create a flat
file by pulling data from both file and DB2 table. I tried using
IMPORT/LOAD utilities to load to a global temporary table and thought
of joining it and extracting, but IMPORT/LOAD are not allowed on
Can you please suggest me how to go about it...
thanks in advance,
Can you Import it to a real TABLE, and then export with a join?
As per my requirements I am not supposed to use a real table. Please
> As per my requ...EXPLAIN and Global Temporary Tables
I have my developers explaining the stored procedures that they write
using visual studio. These stored procedures are for DB2 os390. In
one case, one of the developers has defined a global temporary table
that he uses to put the input parms into and then uses it to join
against to create a dataset. When he runs explain (both visual
explain, and CA's explain) it chokes on the SESSION.TABLE saying that
it doesn't exist.
Is there anyway I can have them explain these when they have global
temporary tables defined?