Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Temporary Tables

Temporary Tables

From: Neil Marshall <marshaln_at_shaw.wave.ca>
Date: Sat, 29 Aug 1998 11:14:28 -0600
Message-ID: <35E836F4.A634C4C0@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 Sat Aug 29 1998 - 12:14:28 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US