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
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 of a
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,