Re: dbms_sql.parse Question

From: Brian Peasland <oracle_dba_at_nospam.peasland.net>
Date: Sat, 8 Apr 2006 16:38:30 GMT
Message-ID: <IxEwwD.1LA@igsrsparc2.er.usgs.gov>

Galen Boyer wrote:
> On Fri, 7 Apr 2006, bob--nospam--_at_dynamicpsp.com wrote:

>> Please enlighten me, what is to be gained by being able to parse DDL
>> without executing it? 

>
> I could see a use for this. I'm developing a patch that has multiple
> modifications. I'm in my local testing area and am readying the file
> that is going to contain these alter statements. As I continue adding
> alters, I'd like to test the file for correctness without having to
> constantly back out the altering.
>

Isn't that what a test database is for? We set up a test database that mimics production. We then apply our changes to the test database, and capture those DDL (or DML) changes in a script. Once the script is built , we are ready to begin testing for release to production. This means we run the script against another test instance. If all passes there, then we are ready to release the script against production.

Cheers,
Brian

-- 
===================================================================

Brian Peasland
oracle_dba_at_nospam.peasland.net
http://www.peasland.net

Remove the "nospam." from the email address to email me.


"I can give it to you cheap, quick, and good.
Now pick two out of the three" - Unknown

Received on Sat Apr 08 2006 - 11:38:30 CDT