Basic Oracle Concepts and Programming Question:
Download Job Interview Questions and Answers 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
SQL> @/u01/oracle/rdbms/admin/catalog.sql
SQL> @/u01/oracle/rdbms/admin/catproc.sql
Download Oracle Database Interview Questions And Answers
PDF
Previous Question | Next Question |
How To Create Additional Tablespaces for an New Database? | What Is PL/SQL? |