logminer使用步驟一(加載分析字典)
2024-07-21 02:33:27
供稿：網友
本步使Oracle具有logminer分析能力
加載utl_file_dir參數和生成dbms_logmnr_d.build 數據字典
SQL*Plus: Release 9.2.0.4.0 - PRodUCtion on Fri Nov 26 10:08:10 2004
Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.
SQL> connect / as sysdba
Connected to an idle instance.
SQL> startup
ORACLE instance started.
Total System Global Area 236000356 bytes
Fixed Size 451684 bytes
Variable Size 201326592 bytes
Database Buffers 33554432 bytes
Redo Buffers 667648 bytes
Database mounted.
Database opened.
SQL> alter system set utl_file_dir='/oraclebackup'; #沒有加scope=spfile參數導致error
alter system set utl_file_dir='/oraclebackup'
*
ERROR at line 1:
ORA-02095: specified initialization parameter cannot be modified
SQL> alter system set utl_file_dir = '/oraclebackup' scope=spfile;
System altered.
SQL> shutdown
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> exit
Disconnected from Oracle9i Enterprise Edition Release 9.2.0.4.0 - Production
With the Partitioning, OLAP and Oracle Data Mining options
JServer Release 9.2.0.4.0 - Production
[oracle@test7 dbs]$ sqlplus /nolog
SQL*Plus: Release 9.2.0.4.0 - Production on Fri Nov 26 10:52:49 2004
Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.
SQL> connect / as sysdba
Connected to an idle instance.
SQL> startup
ORACLE instance started.
Total System Global Area 236000356 bytes
Fixed Size 451684 bytes
Variable Size 201326592 bytes
Database Buffers 33554432 bytes
Redo Buffers 667648 bytes
Database mounted.
Database opened.
SQL> execute dbms_logmnr_d.build('szdb7.ora',/oraclebackup'); #少打了一個’號的原因
ERROR:
ORA-01756: quoted string not properly terminated
SQL> execute dbms_logmnr_d.build ('szdb7.ora','/oraclebackup');
PL/SQL procedure successfully completed.
#其中'/oraclebackup'指的是字典信息文件的存放位置,它必須完全匹配UTL_FILE_DIR的值，例如：假設utl_file_dir = '/oraclebackup/'，則上面這條語句會出錯，只因為UTL_FILE_DIR后面多了一個“/”，而在很多其它地方對這一“/”是不敏感的。 right">（出處：清風軟件下載學院）
