Just query the registry$history view in oracle to view the las t exact date

How can we know the exact updation date of a particular
database?

Question Posted / pavana kumar.s

2 Answers
5803 Views
Satyam, I also Faced
E-Mail Answers

Answer Posted / pavana kumar.s

Just query the registry$history view in oracle to view the las t exact date of update.

Is This Answer Correct ?

2 Yes

0 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

What are the different authentication modes in sql server and how can you change authentication mode? : sql server DBA

1166

You have found corruption in a tablespace that contains static tables that are part of a database that is in NOARCHIVE log mode. How would you restore the tablespace without losing new data in the other tablespaces?

2862

In what script is "snap$" created? In what script is the "scott/tiger" schema created?

2499

what is a crs resource?

1240

What is the difference between clustered and non-clustered index? : sql server DBA

1147

Can you tell me about your experience with the administration of COTS system..? Also, how do you set up seed data..?

2255

What are the recovery models for a database? : sql server DBA

1181

What is dcl? : sql server DBA

1323

What are the differences in clustering in sql server 2005 and 2008 or 2008 r2? : sql server DBA

1061

What are the operating modes in which database mirroring runs? : sql server DBA

1242

What are the different ways you can create databases in sql server? : sql server DBA

1197

what are the types of connection load-balancing?

1047

what is the use of ocr?

1075

what do you understand by flashback feature of oracle?

1046

Explain about your sql server dba experience? : sql server DBA

1160