Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.tools -> Re: temporary tables
Mark D Powell wrote:
>
> Walter T Rejuney <BlueSax_at_Unforgetable.com> wrote:
> >I'm still getting used to the concept of temporary tables in
Oracle 8i.
> >What I don't understand is how they are shared.
> >
> >Let's say I create a temporary table owned by account ABC and
for the
> >sake of simplicity I allow public SELECT,INSERT,UPDATE,DELETE
on the
> >table. At a later point accounts DEF and HIJ log in and both of
them
> >perform inserts into the temporary table and then do a commit.
Will both
> >DEF and HIJ see all of the rows, or only the rows that they have
> >inserted? If it is the latter, then if one of the sessions
ends, will
> >the rows that session entered disappear or will all of the data
be
> >retained until both sessions have ended?
> >
> To be honest I do not have real experience using these new
> objects, but per Ch 10 in the 8i Concepts manual each user will
> see only his data. When the data disappears depends on a
> creation parameter as you can make the table data persistent for
> the duration of the transaction or for the entire session. For
> a transaction specific temporary table the data would be unbound
> on a commit.
>
> -- Mark D. Powell -- The only advice that counts is the advice that
> you follow so follow your own advice. --
That is what I was hoping. Now if I can get just a few more piece of my puzzle worked out I just may be able to design a really good way of doing a particular task that I want to do without leaving clutter all over the database. Received on Tue Aug 15 2000 - 10:15:44 CDT