How to find the date and time of last updated table?
- 4 Answers
- 6177 Views
- I also Faced
- E-Mail Answers
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 a named program unit?
How to drop a stored procedure in oracle?
Point out the difference between user tables and data dictionary?
State the difference along with examples between Oracle 9i, Oracle 10g and Oracle 11i.
How to get execution statistics reports on query statements?
What is define in oracle?
How to view the data files in the current database?
What is the difference between translate and replace?
How do you find out from the RMAN catalog if a particular archive log has been backed-up?
How do we display rows from the table without duplicates?
What is recovery manager in Oracle?
Why do we need integrity constraints in a database?
What do you mean by merge in oracle and how can you merge two tables?
What is an oracle function?
How can we find out the current date and time in oracle?
