Oracle - Build Data Dictionary View in Oracle

Build Data Dictionary View in Oracle

Q

How To Build Data Dictionary View of an New Database in Oracle?

✍: FYIcenter.com

A

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

⇒Creating New Database Instance Manually

⇒⇒Oracle Database Tutorials

2016-10-16, 181👍, 0💬

Popular Posts:

About dba.FYIcenter....

What is dba.FYIcenter.com Website about? dba.FYIcenter.com is a Website for DBAs (database administr...

DROP_EXISTING - Recr...

How To Recreate an Existing Index in SQL Server? If you want to change the definition of an existing...

"ALTER USER" - Chang...

How To Change the Name of a Database User in SQL Server? If you want to change the name of an existi...

What Are Logical/Boo...

What Are Logical/Boolean Operations in SQL Server Transact-SQL? Logical (Boolean) operations are per...

Creating Multi-State...

How To Create an Multi-Statement Table-Valued Function in SQL Server Transact-SQL? To create a multi...