One of our DBAs was all in a huff about some SQL scripts that were developed for us by consultants. The indexes and constraints were declared in the table creation statements, and he wanted them in separate tablespaces. He also wanted to change the use of older Oracle data types to the newer versions. He said he would have to go through all the scripts by hand and it would take a week. According to him it could not be automated.

I wrote a perl script in an afternoon that parsed the SQL scripts and corrected all the problems.