Step 9: Run Scripts to Build Data Dictionary Views (67)
Run the scripts necessary to build views, synonyms, and PL/SQL packages:
CONNECT SYS/password AS SYSDBA
@/u01/oracle/rdbms/admin/catalog.sql
@/u01/oracle/rdbms/admin/catproc.sql
EXIT
The following table contains descriptions of the scripts:
CATALOG.SQL : Creates the views of the data dictionary tables, the dynamic
performance views, and public synonyms for many of the views.
Grants PUBLIC access to the synonyms.
CATPROC.SQL : Runs all scripts required for or used with PL/SQL.
第九步 : 运行创建数据字典视图的脚本
CATALOG.SQL : 创建数据字典表 , 动态性能视图 , 公用同义词 , 赋予PUBLIC权限
CATPROC.SQL : 运行PL/SQL需要或使用的所有脚本
来自 “ ITPUB博客 ” ，链接：https://blog.itpub.net/10599713/viewspace-995591/ ，如需转载，请注明出处，否则将追究法律责任。
-
博文量740
-
访问量2002850
最新文章
- 人力&人手&人才&人物
- oracle树中prior的用法
- Using Supplied Packages to Manage Stored Outlines
- $ORACLE_HOMERDBMSADMIN目录下各SQL的含义
- PRODUCT_USER_PROFILE Table
- Backing Up Server Parameter Files with RMAN
- Backing Up Control Files with RMAN
- Backing Up Individual Tablespaces with RMAN
- Making Whole Database Backups with RMAN
- 目睹奥运火炬传递
