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: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: Sat, 24 Jun 2006 15:27:34 +0200
Message-ID: <dafq92tac12l3vhip5amcsn5qu8is60pac@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
Received on Sat Jun 24 2006 - 08:27:34 CDT

Original text of this message

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