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

Report message to a moderator

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: 68718
Registered: March 2007
Location: Saint-Maur, France, https...
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

Report message to a moderator

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

Report message to a moderator

Previous Topic: Querying objects
Next Topic: Query performance in prod environment
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Tue Dec 03 09:25:40 CST 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.