DB utilities – splitting generated DDL scripts

0 0

Have you ever tried to split the DDL scripts generated by Designer? Pretty tough, isn’t it? Well, I have a nice solution for you: the Perl script sql_split.pl splits the input DDL script(s) as if you had chosen to generate just one object in Designer. For example: if you generate all objects in your application system to cdsddl scripts, Designer generates cdsddl.tab, cdsddl.pks, cdsddl.ind, etc. Now the command:

perl sql_split.pl cdsddl.*


generates the following files:

• TABLE1.tab, TABLE2.tab, …
• PACKAGE1.pks, PACKAGE2.pks, …
• TABLE1.ind, TABLE2.ind, …

Conclusion: the sql_split.pl utility enhances installation, version control and release management of DDL scripts. Due to the fine grained nature of the splitted scripts it is also possible to partially install an application.

About Post Author

Gert-Jan Paulissen

Senior Oracle architect / developer (PL/SQL & Apex) / DevOps engineer.I am happy to be able to combine work and hobby. Software engineer since 1989. Bridge player since 1977 and dutch champion more than 10 times.

gert.jan.paulissen@gmail.com

https://gpaulissen.github.io/blog

Happy

0 0 %

Sad

0 0 %

Excited

0 0 %

Sleepy

0 0 %

Angry

0 0 %

Surprise

0 0 %

Related posts:

RuleGen – the next generation framework for Data Logic (aka Data oriented business rules)?! Uitnodiging: Kom kennismaken met AMIS Re-ordering without procedural code or using a sequence The AMIS Summary of Oracle OpenWorld 2013 is available for download – 60-page white paper Dinsdag 18 september: Oracle Open World & JavaOne 2012 Preview mini-conferenties – 12 presentaties op 1 avond