Home » SQL & PL/SQL » SQL & PL/SQL » How to track DDL Changes and Sourcecode Changes ?
How to track DDL Changes and Sourcecode Changes ? [message #196594] Fri, 06 October 2006 02:15 Go to next message
baskaranprasad
Messages: 13
Registered: August 2006
Location: Bangalore
Junior Member
Hi,

How can I track the DDL Changes and the Source code (Functions, Procedures, Packages & views) changes made for selective schemas in the same trigger? I mean I want to maintain the history of DDL changes and the source code change history. How to do that? Please provide your guideline with some example...

Thanks for your time.



Regards,
B.Prasad
Re: How to track DDL Changes and Sourcecode Changes ? [message #196595 is a reply to message #196594] Fri, 06 October 2006 02:18 Go to previous messageGo to next message
rleishman
Messages: 3724
Registered: October 2005
Location: Melbourne, Australia
Senior Member
You will need an external tool to do that. You can use an Oracle tool (like Designer) or any number of 3rd party tools that can be integrated with the database.

I haven't used it, but I know Quest's SQL*Navigator has some plug-in features that do this.

Ross Leishman
Re: How to track DDL Changes and Sourcecode Changes ? [message #196630 is a reply to message #196594] Fri, 06 October 2006 05:14 Go to previous messageGo to next message
rikfair
Messages: 22
Registered: October 2006
Location: UK
Junior Member
Hi

You can use DDL event triggers to log which changes have been made. The following link gives a basic example of using AFTER DDL ON DATABASE, but that could be changed to ON SCHEMA

http://www.astral-consultancy.co.uk/cgi-bin/hunbug/doco.cgi?11090

Regards

Razz
Re: How to track DDL Changes and Sourcecode Changes ? [message #196709 is a reply to message #196630] Fri, 06 October 2006 12:49 Go to previous message
andrew again
Messages: 2577
Registered: March 2000
Senior Member
http://technology.amis.nl/blog/?p=846
Previous Topic: Inserting dynamic values into a dynamic query.
Next Topic: How to make my Form Module online or how to run on machine without form developer
Goto Forum:
  


Current Time: Fri Dec 09 15:59:15 CST 2016

Total time taken to generate the page: 0.10561 seconds