select b.name, a.analyzetime from tab$ a, obj$ b where a.obj#=b.obj# and

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

Question Posted / aseem k

Answer Posted / aseem k

select b.name, a.analyzetime from tab$ a, obj$ b
where a.obj#=b.obj#
and b.name ='EMP'

Is This Answer Correct ?

0 Yes

0 No

Please Help Members By Posting Answers For Below Questions

Can objects of the same schema reside in different tablespace?

789

What is the scope of a local variable?

761

What is oracle sid?

684

What is user managed backup in Oracle?

833

What is procedure overloading in oracle?

779

Explain the use of record length option in exp command.

804

How to estimate disk space needed for an export job?

759

What is SQL access advisor in Oracle?

854

What are the restrictions on external table columns?

788

How to execute the package in oracle?

808

What is oracle analytical function?

742

How does oracle handle read consistency?

879

How to view existing locks on the database?

774

How can you use check constraints for self referential integrity?

724

What is an Oracle index?

1387