Basic Oracle Concepts and Programming Question:
Download Questions PDF

How To Build Data Dictionary View an New Database?

Answer:

This is Step 9. The Oracle Administrator Guide suggests to run two SQL scripts provided by Oracle as shown bellow:

SQL> @/u01/oracle/rdbms/admin/catalog.sql

SQL> @/u01/oracle/rdbms/admin/catproc.sql


Download Oracle Database Interview Questions And Answers PDF

Previous QuestionNext Question
How To Create Additional Tablespaces for an New Database?What Is PL/SQL?