| a problem about logminer [message #50875] |
Fri, 12 April 2002 00:28  |
www
Messages: 6
Registered: April 2002
|
Junior Member |
|
|
enviroment:win2000+oracle8.1.7
please help me look this spool:
SQL> show parameter utl_file;
NAME TYPE
------------------------------------------------------------------------ -------
VALUE
----------------------------------------
utl_file_dir string
e:
SQL> @dbmslogmnr
程序包已创建。
授权成功。
SQL> @dbmslogmnrd
程序包已创建。
程序包主体已创建。
没有错误。
授权成功。
SQL> alter session set nls_date_language='AMERICAN' ;
会话已更改。
SQL> alter session set nls_date_format='DD-MON-YYYY HH:MI:SS' ;
会话已更改。
SQL> EXECUTE DBMS_LOGMNR_d.BUILD('a.ora','e:');
PL/SQL 过程已成功完成。
SQL> SELECT low_time,high_time,low_scn,next_scn FROM V$LOGMNR_LOGS;
LOW_TIME HIGH_TIME LOW_SCN NEXT_SCN
-------------------- -------------------- --------- ---------
12-APR-2002 10:06:52 12-APR-2002 10:11:03 195667 195702
SQL> EXECUTE dbms_logmnr.add_logfile('E:ORACLEORADATAORA8WQREDO02.LOG',DBMS_LOGMNR.NEW);
PL/SQL 过程已成功完成。
SQL> SELECT low_time,high_time,low_scn,next_scn FROM V$LOGMNR_LOGS;
LOW_TIME HIGH_TIME LOW_SCN NEXT_SCN
-------------------- -------------------- --------- ---------
12-APR-2002 10:06:52 12-APR-2002 10:11:03 195667 195702
SQL> execute dbms_logmnr.start_logmnr(DictFileName=>'e:a.ora',StartScn=>195668,EndScn=>195701,StartTime =>to_date('12-APR-2002 10:07:00'),EndTime=>to_date('12-APR-2002 10:10:00'));
BEGIN dbms_logmnr.start_logmnr(DictFileName=>'e:a.ora',StartScn=>195668,EndScn=>195701,StartTime =>to_date('12-APR-2002 10:07:00'),EndTime=>to_date('12-APR-2002 10:10:00')); END;
*
ERROR 位于第1行：
ORA-01280: 严重的 LogMiner 错误。
ORA-06512: 在"SYS.DBMS_LOGMNR", line 42
ORA-06512: 在line 1
I don't understarnd the last one statement:
execute dbms_logmnr.start_logmnr(DictFileName=>'e:a.ora',StartScn=>195668,EndScn=>195701,StartTime =>to_date('12-APR-2002 10:07:00'),EndTime=>to_date('12-APR-2002 10:10:00'));
is always wrong,
where is the error,please help me
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
