Home » SQL & PL/SQL » SQL & PL/SQL » How to know the constraints hostory. [merged]
How to know the constraints hostory. [merged] [message #398465] Thu, 16 April 2009 06:14 Go to next message
raghu.iv85
Messages: 13
Registered: December 2008
Location: banglore
Junior Member
Hi All,


I want to know when the constraints in a table are modified and who is changed those constraint's status in which PC. I meant is there any data dictionary table to find out these all information? Can You anyone please tell me that table name?

Why becoz in my application some of the table's constraint status is changing regularly.

Thanks in advance.

Regards,
Raghu
Re: How to know the constraints hostory. [message #398467 is a reply to message #398465] Thu, 16 April 2009 06:17 Go to previous messageGo to next message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
dba_constraints.last_change is the ONLY information you have by default.

If you want more you have to activate audit or create a DDL trigger.

Regards
Michel
Re: How to know the constraints hostory. [message #398501 is a reply to message #398467] Thu, 16 April 2009 08:31 Go to previous message
raghu.iv85
Messages: 13
Registered: December 2008
Location: banglore
Junior Member
Thanks Michel
Previous Topic: Querying objects
Next Topic: Query performance in prod environment
Goto Forum:
  


Current Time: Sat Dec 03 01:22:18 CST 2016

Total time taken to generate the page: 0.12047 seconds