How to find the date and time of last updated table?
Answer Posted / manish rathore
I got it from net.
Hope it will serve.
select *
from sys.dm_db_index_usage_stats
where object_id = object_id( '<Table_Name>' )
Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
What is Data Dictionary Cache in Oracle?
How to write text literals in oracle?
What is a select query statement in oracle?
What are the oracle built-in data types?
How to commit the current transaction in oracle?
How many objectname will be created for a single table drop function? Why 'flashback' query giving error "ORA-38312: original name is used by an existing object" while getting the table?
How do I find my oracle client driver version?
What is bulk collect in oracle?
What are the attributes of cursor?
How to create an oracle database?
Does facebook use oracle?
What is the relation of a user account and a schema in oracle?
What is an Oracle index?
Where do we use decode and case statements?
How to lock and unlock a user account in oracle?