DB utilities – splitting generated DDL scripts

1
Share this on .. Tweet about this on Twitter0Share on LinkedIn0Share on Facebook0Share on Google+0Email this to someoneShare on TumblrBuffer this page

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.

Share this on .. Tweet about this on Twitter0Share on LinkedIn0Share on Facebook0Share on Google+0Email this to someoneShare on TumblrBuffer this page

About Author

Oracle Specialist @ MNI 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.

1 Comment