-
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
-
you can get last ddl from dba_objects
last dml you would need auditing I guess
-
select * from user_objects where object_name='TABLENAME'
check out the last_ddl_time column.
not sure of the DML stuff..
Srini
-
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
san
-
What you're asking for is naturally going to be resource intensive.
there was a thread about this at http://asktom.oracle.com a little while ago. You might try searching there.
-
-
logminer
Can I use logminer if the database is in Noarchivelog mode ? I don't think logminer can be used....
Can I audit each table for DML's ? or do I have to audit all the users ?
Thanks,
San
san
-
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|