DB utilities – splitting generated DDL scripts

0 0
Read Time:39 Second

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.
Happy
Happy
0 %
Sad
Sad
0 %
Excited
Excited
0 %
Sleepy
Sleepy
0 %
Angry
Angry
0 %
Surprise
Surprise
0 %

Average Rating

5 Star
0%
4 Star
0%
3 Star
0%
2 Star
0%
1 Star
0%

One thought on “DB utilities – splitting generated DDL scripts

Comments are closed.

Next Post

SVG Viewer for Firefox

The 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 […]
%d bloggers like this: