Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Oracle Temp table help
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?
Received on Mon Jul 26 2004 - 23:16:10 CDT