Hi Mladen,
Thanks for your response.
We are using session temporary tables. I question why a commit is required
to see rows in the session temporary table. Since it is a temporary table,
only the session that inserted rows in the table can see the rows (commit or
no commit). In the sample
Hello,
One of our clients has AIX UNIX v4.3.3 OR v5L and Oracle 9.1. They have
problems with temporary tables as shown in the two scenarios below.
Scenario 1: In one procedure, we insert into a temporary table. In a
different procedure we select from the same temporary table. We use
: Is Anybody Aware of Temporary Table Problem in 9i
Hello,
One of our clients has AIX UNIX v4.3.3 OR v5L and Oracle 9.1.
They have
problems with temporary tables as shown in the two scenarios below.
Scenario 1: In one procedure, we insert into a temporary table. In a
different
Hi,
We have 3 tables involved a query. If all the tables are permanent then we
have a
explain plan with very less cost and query runs very fast BUT
if we use 1 global temporary table..explain plan is different with high
cost...and it seems
it don't use index for other tables also
Title: RE: Temporary table
Harvinder, I'm a little confused. The requirements you describe (up to the last sentence) are a classic example of what Global Temporary Tables are suited for. The last sentence puzzles me since you would only be creating one GTT before deploying the code, not each
Hi,
In our application we need to create temporary table for life of a session
and drop it after the session.
we need this table to be session specific ...2 sessions connected as same
schema user should be able to create
table with the same name..
for example user1. connected as scott
Either you have to read more about global temporary tables or you have to
give more details about your question.
-Original Message-
Sent: Thursday, October 25, 2001 6:35 PM
To: Multiple recipients of list ORACLE-L
Hi,
In our application we need to create temporary table for life
this,
beware that in Oracle DDL statements (create, drop .. ) do a implicit
commit;
Harvinder Singh wrote:
Hi,
In our application we need to create temporary table for life of a session
and drop it after the session.
we need this table to be session specific ...2 sessions connected as same
schema user