Search notes:
$ORACLE_HOME/rdbms/admin/catalog.sql
catalog.sql
creates
basic catalog
views. Specifically, tasks of
catalog.sql
include
create the
data dictionary
views and base tables
create the
dynamic performance views
create public
synonyms
for above
grant public access to these synonyms
The file must be run when
connected as SYSDBA
, after
creating a database
.
See also
catproc.sql
catpcat.sql
runs
catalog.sql
and
catproc.sql
in parallel.
$ORACLE_HOME/rdbms/admin/dbmspool.sql
enables DBA to lock PL/SQL packages, SQL statements, and triggers into the Shared Pool.
catcdb.sql
$ORACLE_HOME/rdbms/admin
Index