Step 9: Run Scripts to Build Data Dictionary Views (67)

tsinglee發表於2007-12-23

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需要或使用的所有指令碼

[@more@]

來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/10599713/viewspace-995591/,如需轉載,請註明出處,否則將追究法律責任。

相關文章