How do we find if any changes in a table
638976Apr 2 2009 — edited Jul 1 2009Hi All,
We have created some tables in an user. when ever we create any table that table name or object name stored in All_objects like that.
if we see that table (all_objects). we can find when table has created and when last DDL performed on respective tables.
i would like to know when table has created (when DDL performed )
along with when DDL performed on that table like
1> one day i can drop constraints.
2> one day i can desiable/enable constarints.
3> one day i can add/change column name/ data type or null to not null.
4> one day i drop some columns
i wanted to know when i have created table and when i changed any above mentioned cases. where can we track historical or at least latest changed.
Regards,
venkat
Edited by: user635973 on Apr 2, 2009 12:44 AM