Tag Archives: ORA-310

测试LOGMINER的时候出现了ORA-310和ORA-334错误。 测试代码如下： SQL> SELECT GROUP# FROM V$LOG WHERE STATUS = ‘CURRENT’; GROUP# ———- 2 SQL> SELECT MEMBER FROM V$LOGFILE WHERE GROUP# = 2; MEMBER ——————————————————————– /oracle/oradata/orcl/redo02.log SQL> EXEC DBMS_LOGMNR.ADD_LOGFILE(’/oracle/oradata/orcl/redo02.log’, DBMS_LOGMNR.NEW) PL/SQL PROCEDURE successfully completed. SQL> EXEC DBMS_LOGMNR.START_LOGMNR(OPTIONS => DBMS_LOGMNR.DICT_FROM_ONLINE_CATALOG) PL/SQL … Continue reading →