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:
> "Sybrand Bakker" <postbus_at_sybrandb.demon.nl> wrote in message
> news:dafq92tac12l3vhip5amcsn5qu8is60pac_at_4ax.com...
> : On Sat, 24 Jun 2006 14:54:03 +0200, "Joseph Balsamo" <r5tr_at_free.fr>
> : wrote:
> :
> : >> Better but still a very bad idea. What is the business case for
> : >> implementing a known bad practice of creating tables with procedural
> : >> code?
> : >
> : >Just for my information, may I ask why it is a bad practice ?
> : >
> :
> : Databases happen to be designed. Adding tables on the fly is not a
> : proper design procedure.
> : You create your tables in a relational database management system.
> : How can any DBA guarantee consistency, when your program is treating
> : the database as a replacement for flat files, or as a replacement for
> : a garbage bin?
> :
> : --
> : Sybrand Bakker, Senior Oracle DBA
>
> Sybrand, have you guys every heard of installation scripts?
>
> ++ mcs
Yes and it is irrelevant. Have you heard of CREATE SCHEMA?
Running scripts != PL/SQL when it comes to DDL.
-- 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 Mon Jun 26 2006 - 14:45:57 CDT