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

How to check the oracle tns settings?

1088

Explain oracle left join with an example?

1063

Describe varray?

1116

What is the maximum number of triggers that can be applied to a single table?

1068

What is recovery manager(rman) backup in Oracle?

1231

How to drop a tablespace?

1085

Explain what are the different type of segments?

1003

What are the original export and import utilities?

1258

In SAP ECC 6.0 , under DB02 tcode , Tablespace name to be explain stepy step all the col

4233

Is there a function to split a string in plsql?

1109

How to export data with a field delimiter?

1085

How to get execution statistics reports on query statements?

1153

What is the use of oracle?

1078

What is a subquery in oracle?

1166

Why should I use oracle database?

1045