Re: Temporary Tables

From: Jerry Gitomer <jgitomer_at_ictgroup.com>
Date: Tue, 01 Sep 1998 13:13:26 GMT
Message-ID: <WpSG1.15$Yp2.25458@client.news.psi.net>

Hi Neil,

I haven't done this for a while so I might screw up some of the details, but ... When you create the temporary table make it a compound name consisting of the userid concatenated with the table name. If you have all of your users logging in with the same userid than just use the operating systems process id.

regards

Jerry

Neil Marshall wrote in message <35E83E2D.BFCE75B8_at_shaw.wave.ca>...
>I am assigned to create a Crystal report. It requires to retrieve data
>from Oracle 8 through stored procedures due to the complexity. What it
>is really necessary to process is create a few temporary tables. Oracle
>people mentioned me that Oracle has no ability of creating these
>particular ones -- all I have to do is create tables at the beginning
>and delete them at the end of procedures. Agree with them. No
>problem. My just concern is that what if many users are running the
>report at the same table. Will created tables be messed up? Or Will
>they be created "privately" in their own directory?
>Please clarify this for me. Thanks.
>
>
>
>
>
Received on Tue Sep 01 1998 - 08:13:26 CDT