UTLXPLAN.SQL file default location - Oracle Distributed Database concepts

Q.  Where is the file UTLXPLAN.SQL by default located?
- Published on 27 Jul 15

a. $ORACLE_HOME/rdbms/admin directory
b. $ORACLE_HOME/rdbms/admin/network directory
c. $ORACLE_HOME/rdbms/ directory
d. $ORACLE_HOME/rdbms/admin/dbs directory

ANSWER: $ORACLE_HOME/rdbms/admin directory

Related Content

 

    Discussion

  • Nirja Shah   -Posted on 21 Sep 15
    - The default query tables are present within the SCOTT schema.

    - If it is not already present, it can be created using the utlsampl.sql script found in the $ORACLE_HOME/rdbms/admin directory.

➨ 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.)
▲