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

Home -> Community -> Usenet -> c.d.o.misc -> Re: Create a table only if the table doesn't exists

Re: Create a table only if the table doesn't exists

From: DA Morgan <damorgan_at_psoug.org>
Date: Tue, 27 Jun 2006 08:42:29 -0700
Message-ID: <1151422953.419223@bubbleator.drizzle.com>


Mark C. Stock wrote:

> : If there is any value in creating tables using PL/SQL (and yes I'll
> : grant that Oracle does in some cases such as AQ) Oracle would use it.
> : I've yet to find a single line in sql.bsq or catalog.sql that would
> : indicate this is a good practice.
> : --
> : 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
>
> i'm not talking about building schemas or initializing new databases -- i'm
> talking maintenance scripts that do not have a predictable environment (read
> a little more slowly and carefully, it helps)
>
> ++ mcs

I am too. I read carefully and still, respectfully, disagree.

Take a look at the scripts used for patching, look at $ORACLE_HOME/rdbms/admin/a1001000.sql, c1002000.sql, e1002000.sql, etc.

-- 
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 Tue Jun 27 2006 - 10:42:29 CDT

Original text of this message

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