select table_name, to_char(last_analyzed, 'DD-MM-YY HH:MI:SS') f

How to find the date and time of last updated table?

Question Posted / manoj

Answer Posted / manoj

select table_name, to_char(last_analyzed, 'DD-MM-YY
HH:MI:SS') from user_tables where last_analyzed in (select
max(last_analyzed) from user_tables)

Is This Answer Correct ?

2 Yes

7 No

Please Help Members By Posting Answers For Below Questions

Explain table?

1098

What is the cache hit ratio, what impact does it have on performance of an Oracle database and what is involved in tuning it?

2114

How to recover a dropped table in oracle?

1021

What is archive log in Oracle?

1117

What is rowid and rownum in oracle?

992

Use of an integrity constraint is better to validate data. Explain

1022

How to drop a stored function?

1124

What is oracle rownum?

930

In not less than 100 words what's the main difference between Rolap and Molap in ORACLE ?

2261

What is raw datatype?

1113

In the oracle version 9.3.0.5.0, what does each number shows?

1278

What is the usage of analyze command in oracle?

1077

Select all the employees who were hired in last 2 years and who works in dept where max managers are working.

2942

How to convert a string to a date in oracle database?

1030

Is oracle an operator?

910