Oracle OCP 1Z0 053 Q430(Transfer Database&DBMS_TDB.CHECK_DB)

abstractcyj發表於2016-04-03
430.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.
Answer: C

這個函式是用於檢查是否可以將一個資料庫transfer到另外一個平臺。

參考:http://docs.oracle.com/cd/E11882_01/appdev.112/e40758/d_tdb.htm#ARPLS68864

而執行結果如下

SQL> set serveroutput on
SQL> declare
  2    v_1 boolean;
  3  begin
  4    v_1 := dbms_tdb.check_db;
  5  end;
  6  /
Database is not open in READ-ONLY mode. Open the database in READ-ONLY mode and
retry.


PL/SQL procedure successfully completed.

來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/8520577/viewspace-2074522/,如需轉載,請註明出處,否則將追究法律責任。

相關文章