Re: Temporary table

Hi

I don't understand why you need to create the table and drop the table ? If you don't create/drop the table it sounds to me that Global Temporary Tables is the thing for you to use. If you have to waste resources on creating/droping tables in Oracle there is know easy way to do 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 should be able to create
>table with the same name......
>for example user1. connected as scott create table with name tab1..then
>user2 connected as scott should also be
>able to create table with name tab1...and we want table tab1 to be dropped
>as soon as user1 and user2 will discconnect....
>We need to populate this temporary table in particular session and use it to
>join with other tables and then drop after the session.....
>How can we implement this.......
>global temporary table does not allow to be created twice in 1 schema..they
>r schema specific.......
>
>Thanks
>-Harvinder
>

-- 
Regards

Peter Gram

Miracle A/S 
http://MiracleAS.dk 
Tel: +45 2527 7107



-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Peter Gram
  INET: peter.gram_at_miracleas.dk

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).