Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

How to identify the DDL changes ?

user546710Nov 4 2008 — edited Nov 4 2008
Hi all,

How to identify the DDL changes done to the database ?
By triggers only Or we can use Logminer also OR

SELECT * FROM USER_OBJECTS where object_type = 'TABLE' order by LAST_DDL_TIME desc;
OR
is there any other options are available ?

Thanks in advance,
Pal
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Dec 2 2008
Added on Nov 4 2008
4 comments
6,419 views