Oracle DB Error ORA-01307 no LogMiner session is currently active

The following is the cause of this error:

A select was issued from V$LOGMNR_CONTENTS without first invoking the DBMS_LOGMNR.START_LOGMNR() procedure. Otherwise, DBMS_LOGMNR.END_LOGMNR() was called without a prior call to DBMS_LOGMNR.START_LOGMNR() or DBMS_LOGMNR.ADD_LOGFILE()

Action you can take to resolve this issue: Invoke the DBMS_LOGMNR.START_LOGMNR() procedure before issuing a select from the V$LOGMNR_CONTENTS view.

Tags: Database, Education, Software

DISCLAIMER

Paked and the contributors are not responsible for any errors contained and are not liable for any damages resulting from the use of this material.

Disclaimer

Other

Oracle DB Error ORA-01308 initialization parameter utl_file_dir is not set

Oracle DB Error ORA-01309 invalid session

Oracle DB Error ORA-01310 requested return type not supported by the lcr_mine function

Oracle DB Error ORA-01311 Illegal invocation of the mine_value function

Oracle DB Error ORA-01312 Specified table/column does not exist

Oracle DB Error ORA-01313 LogMiner dictionary column type different from specified type

Home Disclaimer Advertise Contact Privacy Policy

Note: Site best viewed at 1024 x 768 or higher screen resolution