CODEWITHSUNDEEP
databaseoracle-databasetoaddatabase-scripts
ardal
ardal

Reputation: 1617

Check if oracle script is valid and will run ok on another database

I'm wondering if there is a tool that will let me check if a oracle script will run fine on another database (if my script from DEV db will run ok on QA db). I don't want to run/execute anything there (I dont have permisson), I just want to verify that once someone runs the script, it will execute without errors. Is this possible at all?

I use Toad for Oracle as my current IDE.

Upvotes: 1

Views: 921

Answers (1)

wolφi
wolφi

Reputation: 8361

The usual approach is to take a copy of the production database into a test database and apply the script on the test database.

If you don't have a spare test database, you can recreate the DEV db from production (at least the structure) and run the test on your DEV database.

Upvotes: 0

Related Questions