Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: SQL possible equivalent
<snip>
>There is generally no valid reason to drop and recreate tables in
>production code. If you need a work table then you either use a
>permanent table that is truncated either directly before or after each
>use or a global temporary table which is defined only once and used
>when needed.
>
>The need for work tables is itself usually questionable. The non-
>blocking nature of the Oracle locking and read consistency model plus
>the ability of Oracle to handle complex queries generally allows
>removing work tables from the process.
>
>HTH -- Mark D Powell --
The reason is to handle a reinstall of a failed install for a product.
The script is run by an installation application.
thanks
Jeff Kish
Received on Wed May 30 2007 - 09:37:00 CDT