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: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
