From U - Foreign Key Create Script

The script comes from Chris Brown. Thanks Chris for sending this to me.

It accepts one command line parameter and creates "a create script" for all
the foreign keys pointing to a table. It allows you to do things like "drop
table ... cascade constraints" and re-create the table without losing the
dependant foreign keys by running the generated script after re-creating
the table.

CLICK HERE FOR THE SCRIPT

The next script is from Jack de Hamer. Thanks Jack, it is very nice of you to send the script. 

I have made some adjustments to the gensql script, to fit it to my particular needs. Below you will find some of the adjustments made to the package. 1. When using the procedure generate_view_sql, I received some errors on more complex views when trying to create them on the target database. Therefore I made these adjustments. Maybe they are useful for other users of the package gensql too

CLICK HERE FOR THE GENSQL PATCH FROM JACK

Search BijooS.com Exact Match Search      
Home Oracle DBA TKMCE Alumni H1B Info Guestbook

Biju Thomas is Oracle7.3 OCP, Oracle8 OCP, 
Oracle8i OCP and Oracle9i OCA/OCP Certified DBA

Questions/Comments? Write to webmaster@bijoos.com. The scripts, tips and articles appearing on BijooS.com cannot be reproduced elsewhere without the prior permission from the webmaster.