DDL ,DML on ables & Views
Hi All ,
Is there any way to find out the last DDL or DML statement on a view or table ? I need a date and time that the DML or DDL executed on a table or view.....
We have number of unnecessary tables created in a schema and want to drop them from the database.....
Thanks,
San
DDL ,DML on tables & Views
Thanks you All .....
I need the DML info on the tables , Putting audit on all users in the database and searching for these tables in the audit files is a cumbersome process and also resouce intensive...
Can somebody suggest me a best mothod to do this ?
Thanks,
San