Re: SQL possible equivalent

From: DA Morgan <damorgan_at_psoug.org>
Date: Wed, 30 May 2007 08:11:49 -0700
Message-ID: <1180537908.12967@bubbleator.drizzle.com>

Jeff Kish wrote:

> <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

Wrong solution. Look up CREATE SCHEMA

Morgan's Library at www.psoug.org
Scroll down to CREATE SCHEMA

Anyone building objects and not using this syntax is just making a simple job more difficult.

-- 
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu
(replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org

Received on Wed May 30 2007 - 10:11:49 CDT