Shulou(Shulou.com)05/31 Report--

This article is mainly about "what are the scripts that come with oracle". Interested friends may wish to have a look at them. The method introduced in this paper is simple, fast and practical. Let's let the editor take you to learn "what are the oracle's own scripts?"

Creating a database looks easy, but it is difficult to do it. If you create it manually, you need to know the contents of the database and know which scripts can be executed for each function. So this article collects some script instructions and how to use rdbms and other directories in oracle.

The path of $ORACLE_HOME is not written, only the relative path is written. If these scripts are not used and don't know whether to add parameters, open the script first and check the description of the header to see if you need to write parameters when executed.

1. @? / rdbms/admin/catlog.sql

After executing the script, create a statistical view of the database and audit the view.

2. @? / rdbms/admin/catexp.sql

After executing this script, the database has the import and export function, that is, you can use exp, imp, expdp, impdp.

3. @? / rdbms/admin/catproc.sql

The database has the function of pl/sql.

4. @? / rdbms/admin/cataudit.sql

Create an audit data dictionary view

5. @? / rdbms/admin/ownctab.plb

@? / rdbms/admin/owmaggrs.plb

@? / rdbms/admin/owmaggrb.plb

The execution of these three scripts is used to create wmsys users, using the column-to-row function wm_concat function. Note, however, that this function cannot be written to the program, because the field type returned by this function is different in different oracle versions. The field type returned above 10.2.0.5 is clob type, and the previous one is varchar2 type.

6. @? / rdbms/admin/catblock.sql

Create views about locks, including DBA_KGLLOCK, DBA_LOCKS, DBA_LOCK_INTERNAL, DBA_DML_LOCKS, DBA_DDL_LOCKS, DBA_WAITERS, DBA_BLOCKERS

7. @? / rdbms/admin/catexp7.sql

Resolve compatibility issues with different versions of EXp.

8. @? / rdbms/admin/catjobq.sql

Create a view of the job.

9. @? / rdbms/admin/utlxplan.sql

Create using the autotrace tracking tool, execute the script after execution: CREATE PUBLIC SYNONYM PLAN_TABLE FOR PLAN_TABLE;GRANT ALL ON PLAN_TABLE TO PUBLIC

10. @? / sqlplus/admin/plustrce.sql (Note: this is the script in the sqlplus directory)

Create a plustrace role, grant plustrace to public, so that all users can use the autotrace tracking tool.

11. @? / rdbms/admin/spcreate.sql

Statspack is configured, a perfstat user is created, and during execution, the user is prompted for the table space and temporary table space that the user uses.

If execution fails, execute @? / rdbms/admin/spdrop.sql to uninstall the user and the created view before executing the creation script above.

12.@?/rdbms/admin/dbmshord.sql

DBMS_REDEFINITION, online redefinition of various types of methods. After executing the above script, you need to assign permissions:

ALTER ANY TABLE

CREATE ANY TABLE

DROP ANY TABLE

LOCK ANY TABLE

SELECT ANY TABLE

The following privileges may be required too:

CREATE ANY INDEX

CREATE ANY TRIGGER

PLS-00201: identifier 'DBMS_REDEFINITION' must be declared may be reported in the course of use.

However, if we have created the package or will report it, we need to give the corresponding user permission to use it.

GRANT ALL ON SYS.DBMS_REDEFINITION TO TEST; solves the above problem in this way.

13.@?/rdbms/admin/dbmsutil.sql is aimed at DBMS_SYSTEM

GRANT EXECUTE ON DBMS_SYSTEM TO username

14.@?/javavm/install/initjvm.sql for missing DBms_java

After executing the script, you can add java code to oracle

15.@?/javavm/install/initjvma.sql installs the java component.

14 and 15 must be installed together for oracle to use the java feature properly.

Select * from v$option t where t.PARAMETERTHANG Java'

Select distinct owner,name from dba_source where lower (NAME) = 'dbms_java'

At this point, I believe you have a deeper understanding of "what are the oracle's own scripts?" you might as well do it in practice. Here is the website, more related content can enter the relevant channels to inquire, follow us, continue to learn!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.