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

What is the meaning of recursive hints in oracle?

532

How do you increase the OS limitation for open files (LINUX and/or Solaris)?

1468

What is set verify off in oracle?

579

What is a database schema in oracle?

625

What is oracle join syntax?

570

How do I know if oracle client is installed on windows?

498

How to divide query output into groups in oracle?

563

What is proxy method?

545

Explain the use of rows option in imp command.

604

What is an oracle database?

612

How to concatenate two text values in oracle?

593

State any two functions of oracle?

636

What privilege is needed for a user to delete rows from tables in another schema?

562

How to start your 10g xe server?

596

How are extents allocated to a segment?

582