how do you handle your DDL builds?

From: Rick Ricky <ricks12345_at_gmail.com>
Date: Wed, 14 May 2008 10:08:29 -0400
Message-ID: <81f4c0700805140708t21765c4ai2d1c338ae7824731@mail.gmail.com>


We have a production database. We want to change tables, structure, etc... We do this frequently. How do you script this? So far I have been using upgrade directories.
upgrade

     version1
     version2

However, this leaves me with a problem. I can do an add column to a table in version1, but then I have to change my base DDL of the table, but how do I know that table works? Where would I test that my new create table statement works? You can do all this manually, but its slow, time consuming, and prone to bugs.

--
http://www.freelists.org/webpage/oracle-l
Received on Wed May 14 2008 - 09:08:29 CDT

Original text of this message