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, 254👍, 0💬

Popular Posts:

RAND() - Generating ...

How To Generate Random Numbers with the RAND() Function in SQL Server Transact-SQL? Random numbers a...

Error: Lock Wait Tim...

What Happens to Your Transactions When ERROR 1205 Occurred in MySQL? If your transaction receives th...

Managing Security, L...

Where to find answers to frequently asked questions on Managing Security, Login and User in SQL Serv...

CONVERT() - Converti...

How To Convert Numeric Expression Data Types using the CONVERT() Function in SQL Server Transact-SQL...

OUTPUT - Defining Ou...

How To Define Output Parameters in Stored Procedures in SQL Server Transact-SQL? Sometime a stored p...