CATALOG.SQL is used in run scripts to build data dictionary views - Oracle DBA

Q.  In Run Scripts to build data dictionary views which script Creates the views of the data dictionary tables, the dynamic performance views, and public synonyms for many of the views, Grants PUBLIC access to the synonyms?
- Published on 19 Oct 15

a. CATALOG.SQL
b. CATPROC.SQL
c. Both A & B
d. None of the above

ANSWER: CATALOG.SQL
 

    Discussion

  • Nirja Shah   -Posted on 25 Aug 15
    -Run the scripts necessary to build data dictionary views, synonyms, and PL/SQL packages, and to support proper functioning of SQL*Plus

    -The scripts used are:

    -CATALOG.SQL - It creates the views of the data dictionary tables, the dynamic performance views, and public synonyms for many of the views. Grants PUBLIC access to the synonyms.

    -CATPROC.SQL - It runs all scripts required for or used with PL/SQL.

    -PUPBLD.SQL - It is required for SQL*Plus. Enables SQL*Plus to disable commands by user.

Post your comment / Share knowledge


Enter the code shown above:

(Note: If you cannot read the numbers in the above image, reload the page to generate a new one.)