Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Oracle Temp table help
"temp table help" <temp_at_temptable.com> wrote in message
news:10gbi0hrn9c3840_at_corp.supernews.com...
> X-No-Archive: yes
>
> > One last question though: How do you specify the scope of a temp table
to
> > be session-levl as opposed to transaction-level?
> >
> > thanks again!!!
>
> Never mind. I saw the "on commit preserve rows" option to the create
> temporary table statement.
>
> thanks again. I feel comfortable with them now :-)
>
> Tell me this though, if a "system" is going to have a lot of different
> temporary tables (say maybe 10 or 20), is it best
> practice to perhaps create a seperate schema for these temp tables and use
> synonyms to access them in the regular
> user schema?
>
>
>
You create temp tables once and you don't specify where. (they go in the
owner's default temporary tablespace) It is rare that you need them.
Jim
Received on Mon Jul 26 2004 - 23:42:30 CDT