Which of the following is a prerequisite for running DBMS_TDB.CHECK_DB to a successful completion?

Which of the following is a prerequisite for running DBMS_TDB.CHECK_DB to a successful
completion?

Which of the following is a prerequisite for running DBMS_TDB.CHECK_DB to a successful
completion?

A.
The database must be in read-write mode.

B.
The database must have no external files.

C.
The database must open in read-only mode.

D.
The database must be mounted but not opened.



Leave a Reply 3

Your email address will not be published. Required fields are marked *


Eamon

Eamon

True, but the version of Oracle used in this test is 11.2.0.1 not 10.2

Jake from SF

Jake from SF

C is correct:

https://docs.oracle.com/cd/B28359_01/appdev.111/b28419/d_tdb.htm

In many cases, Oracle supports transporting databases between platforms which have the same endian format. However, even when the endian formats are the same, a database must undergo a conversion process to move from one platform to another. There are also preconditions required for the process of transporting a database, such as having the database to be transported OPEN READ-ONLY.

The DBMS_TDB package serves two purposes:

Confirming that Oracle supports transporting a database from a given source platform to a given target platform

Determining whether a database to be transported has been properly prepared for transport, and if not, identifying the condition that prevents database transport