DB utilities – splitting generated DDL scripts

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.

One thought on “DB utilities – splitting generated DDL scripts

Comments are closed.

Next Post

SVG Viewer for Firefox

Facebook0TwitterLinkedinThe Adobe SVG Viewer is a viewer for Scalable Vector Graphics like charts and graphics and, as I found out, is used by Oracle in web-applications. It’s downloadable at Adobe downloads. However, the plugin only works for Internet Explorer. With some minor tweaks it’s possible to make it available under […]