Re: Oracle Temp table help

"temp table help" <temp_at_temptable.com> wrote in message news:10gbdk4mj3quc6c_at_corp.supernews.com...
> X-No-Archive: yes
>
> I'm trying to learn how to create a temp table as well as to specify
whether
> it's session or transaction scope.
>
> I'm coming up empty in terms of finding a good web page that describes
this
> process. The one's that I have found
> want you to pay a monthly fee. The oracle concepts manual that I
> downloaded did not provide me with sufficient
> information.
>
> Just want to see an example of how to create the 2 types of temp tables
and
> how to play around with adding/deleting rows from it.
>
> Also, in the past, I used to work with Informix. We were constantly
> creating/dropping temp tables on-the-fly. I heard that is not
> the best way in Oracle (and it is recommended against doing so). The
only
> thing that's "slightly" disturbing about creating temp tables
> "and leaving their definition in the data dictionary on a permant basis"
> once rather than "on-the-fly" is that there could be alot of these
> definitions in the data dictionary if you have a system that requires many
> temp tables of different types (ie, like a scrubber/loader or a
> system with alot of staging data tables).
>
> thanks again!!!
>
>

You don't need temp tables created on the fly. If you really, really, really think you do look up global temporary tables in the docs. (SQL guide and it is on line or you can download it from otn.oracle.com for free.)

Jim Received on Mon Jul 26 2004 - 21:10:28 CDT