> Daniel : Yes users should be able to truncate these 10 tables (not
> directly, only with the procedure call). These tables simply store the
> results of an algorithm, and every time it is ran the old results are
> truncated.
Sounds like perfect candidates for being GLOBAL TEMPORARY tables...
These do truncate themselves automatically either at transaction end
or at session end (depends on ON COMMIT clause used for creating
the table) and isolate each session's data from other sessions in the
meanwhile... However, if algorithm results should survive beyond
session duration and/or be available to other sessions then GTTs
don't fit here.
--
Vladimir Zakharychev (bob@dpsp-yes.com) http://www.dpsp-yes.com
Dynamic PSP(tm) - the first true RAD toolkit for Oracle-based internet applications.
All opinions are mine and do not necessarily go in line with those of my employer.
Received on Tue Dec 10 2002 - 09:30:23 CST
