The created tables are private in each user's schema. You are better
off truncating the table rather than dropping it each time.
Nabil Courdy
Neil Marshall wrote in message <35E836F4.A634C4C0_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 Mon Aug 31 1998 - 16:51:11 CDT
