Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Create a table only if the table doesn't exists
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.orgReceived on Tue Jun 27 2006 - 10:42:29 CDT