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

Answers were Sorted based on User's Feedback



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

Answer / 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

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

Answer / guest

Schdule a job for required database.
Every day it will give the job history.

Is This Answer Correct ?    5 Yes 5 No

Post New Answer

More DB Administration Interview Questions

List out some of the requirements to setup a sql server failover cluster.? : sql server DBA

0 Answers  


what is the use of home directory???

1 Answers   HP,


Explain the difference between ARCHIVELOG mode and NOARCHIVELOG mode and the benefits and disadvantages to each.

5 Answers  


when we login sql editor using username and password then it says this error "could not resolve service name" then what can we do at client side.( here thing is tnsnames.ora file is ok till yesterday and worked well, but now it giving error.

0 Answers  


I lost one datafile i dont have backup how can you recover that???

2 Answers   HP,






how can you record information about current session?

0 Answers   Oracle,


What are the different types of indexes available in sql server? : sql server DBA

0 Answers  


What is the default port no on which sql server listens? : sql server DBA

0 Answers  


What command would you use to create a backup control file?

2 Answers  


i want export 50gb data in datapump it will take 2 hours time to complete that how can u export that tell me script ???

1 Answers   iGate,


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

0 Answers  


Explain the difference between $ORACLE_HOME and $ORACLE_BASE.

3 Answers  


Categories