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

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

Question Posted / sqlprabha

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

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 an oracle clusterware manage crs resources?

0 Answers Oracle,

How many packages we have in db

1 Answers Tesco,

How to start SQL Server in minimal configuration mode?

1 Answers

What is the difference between the 2 operating modes of database mirroring? : sql server DBA

0 Answers

How do you add a data file to a tablespace?

3 Answers

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

what is ora 600?

1 Answers

What is the default fill factor value? : sql server DBA

0 Answers

What is a system database and what is a user database? : sql server DBA

0 Answers

Explain how you would restore a database using RMAN to Point in Time?

1 Answers

Name three advisory statistics you can collect.

1 Answers

What the different types of replication and why are they used? : sql server DBA

0 Answers

For more DB Administration Interview Questions Click Here