Subscribe YouTube Channel For More Live Tutorials

What scripts used to create dictionary tables?

Creating the Data Dictionary Scripts

To run these scripts, you must be connected to Oracle as a user with SYSDBA privileges. (eg: sys user)

Script NameNeeded ForDescription
catalog.sqlAll databasesCreates the data dictionary and public synonyms for many of its viewsGrants PUBLIC access to the synonyms
catproc.sqlAll databasesRuns all scripts required for, or used with, PL/SQL
catpcat.sqlAll databasesRuns the catalog.sql and catproc.sql scripts as parallel processes, which can speed up database creation.

Note: You must run catpcat.sql by using the catctl.pl program.
catclust.sqlOracle Real Application ClustersCreates Oracle Real Application Clusters data dictionary views
In Which Tablespace will be created these dictionary tables?

System Tablespace.

The data dictionary base tables are the first objects created in any Oracle database. They are created in the SYSTEM tablespace and must remain there. The data dictionary base tables store information about all user-defined objects in the database.

Oracle automatically creates the data dictionary using DBCA Database Configuration Assistant.

Oracle SQL Data Dictionary Tables