下面是创建data dictionary views, synonyms, and PL/SQL packages, and to support proper functioning of SQL*Plus的脚本:
@?/rdbms/admin/catalog.sql
@?/rdbms/admin/catproc.sql
@?/sqlplus/admin/pupbld.sql
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.
PUPBLD.SQL:
Required for SQL*Plus. Enables SQL*Plus to disable commands by
DBMSSTDX.SQL:
Before a trigger can be created, the user SYS must run this SQL script
STANDARD.SQL:
Before run PL/SQL, the user SYS must run this SQL script
阅读(1903) | 评论(0) | 转发(0) |