Home » Other » General » Temp table (Oracle 9.2, Windows)
Temp table [message #446901] Wed, 10 March 2010 23:32 Go to next message
visuorac
Messages: 10
Registered: February 2010
Location: chennai
Junior Member
Hi,

I have created temporary table in oracle database.
When the session expired the table will lost. But
Only data was lost table is exist.Please share your thoughts.
Re: Temp table [message #446904 is a reply to message #446901] Wed, 10 March 2010 23:36 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Database Concepts
Chapter 5 Schema Objects
Section Overview of Tables
Paragrah Temporary Tables

98% of such questions are answered in this book, please read it.

Regards
Michel
Re: Temp table [message #446910 is a reply to message #446901] Wed, 10 March 2010 23:41 Go to previous messageGo to next message
ramoradba
Messages: 2456
Registered: January 2009
Location: AndhraPradesh,Hyderabad,I...
Senior Member
TemporaryTables

sriram Smile
Re: Temp table [message #446914 is a reply to message #446901] Wed, 10 March 2010 23:53 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
visuorac wrote on Wed, 10 March 2010 21:32
Hi,

I have created temporary table in oracle database.
When the session expired the table will lost. But
Only data was lost table is exist.Please share your thoughts.


provide reproducible test case & answer own question otherwise spare us your idle speculation
Re: Temp table [message #447084 is a reply to message #446914] Thu, 11 March 2010 21:03 Go to previous messageGo to next message
djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS Australia
Senior Member
Account Moderator
No 'commit'?

David
Re: Temp table [message #447148 is a reply to message #447084] Fri, 12 March 2010 00:36 Go to previous messageGo to next message
Littlefoot
Messages: 21806
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Commit? /forum/fa/1600/0/

As far as I understood the problem, this is what happened:
- the OP created a global temporary table
- worked with it for a while
- session was over (no matter how - for example, he/she disconnected from Oracle)
- as the OP returned back, the table was still there. It was empty, though, but it existed.
- the OP was puzzled why? as he/she expected that "temporary" means that it will be dropped once the session ends

Perhaps I misunderstood the whole story /forum/fa/3314/0/
Re: Temp table [message #447190 is a reply to message #446901] Fri, 12 March 2010 04:34 Go to previous messageGo to next message
cookiemonster
Messages: 13917
Registered: September 2008
Location: Rainy Manchester
Senior Member
That was my understanding too.
Think OP thinks they work like temp tables in sqlserver.
Re: Temp table [message #447390 is a reply to message #447190] Mon, 15 March 2010 00:35 Go to previous message
djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS Australia
Senior Member
Account Moderator
Maybe his 'temporary' table is one that he only wants to use for a week or so. He creates the table, populates it, but when he comes back the next day the records are missing. No 'commit', so the records do not exist outside of the session that created them.

David
Previous Topic: How to know RDBMS latest market share report
Next Topic: Clubbing Alter session in SQL
Goto Forum:
  


Current Time: Thu Mar 28 17:57:51 CDT 2024