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

How does Oracle guarantee data integrity of data changes?

1 Answers   SoftSol,


I want to export only structure of the table from oracle database. In that table to used the some partition. To export the table in general way then compilation error was occured i.e-EXP-00003: no storage definition found for segment(11, 2771). Please tell me the correct export command parameter to export the partitioned table. Thanks in Advance..........

1 Answers  


From the database level, how can you tell under which time zone a database is operating?

1 Answers  


I have my backup RMAN script called "backup_rman.sh". I am on the target database. My catalog username/password is rman/rman. My catalog db is called rman. How would you run this shell script from the o/s such that it would run as a background process?

1 Answers  


deleted of control file how will u recover control file?

4 Answers   CTS,






what is the last version,the release date of that version and fix pack of ibm db2 udb?

0 Answers  


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

0 Answers  


Database is hung. Old and new user connections alike hang on impact. What do you do? Your SYS SQLPLUS session IS able to connect.

0 Answers  


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

0 Answers  


What column differentiates the V$ views to the GV$ views and how?

3 Answers  


how do we explain a project in cognos in an interview? please help me. Also how do we perform testing in cognos after creating reports?

0 Answers   HSBC,


what are the types of connection load-balancing?

0 Answers   Oracle,


Categories