Which of the following supplied functions is used to identify external tables, directories, and
BFILES?
A.
DBMS_TDB.CHECK_DIRECTORIES
B.
DBMS_TDB.CHECK_EXTERNAL
C.
DBMS_TDB.CHECK_BFILE
D.
DBMS_TDB.CHECK_EXT
Which of the following supplied functions is used to identify external tables, directories, and
BFILES?
Which of the following supplied functions is used to identify external tables, directories, and
BFILES?
A.
DBMS_TDB.CHECK_DIRECTORIES
B.
DBMS_TDB.CHECK_EXTERNAL
C.
DBMS_TDB.CHECK_BFILE
D.
DBMS_TDB.CHECK_EXT
B is correct:
https://docs.oracle.com/cd/B19306_01/appdev.102/b14258/d_tdb.htm#BDCCBGDD
This example illustrates the use of CHECK_EXTERNAL with a database that has several external tables, directories and BFILEs: