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

The following is the cause of this error:

An attempt was made to use the MINE_VALUE function on a column other than redo_value or undo_value columns of SYS.V$LOGMNR_CONTENTS fixed table/view.

Action you can take to resolve this issue: Rewrite the SQL statement with a legal invocation of MINE_VALUE.

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-01312 Specified table/column does not exist

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

Oracle DB Error ORA-01314 Name of the column to be mined should be a string literal

Oracle DB Error ORA-01315 Log file has been added or removed during select

Oracle DB Error ORA-01316 Already attached to a Logminer session

Oracle DB Error ORA-01317 Not attached to a Logminer session

Home Disclaimer Advertise Contact Privacy Policy

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