HomeOracleOracle Error ORA-42023: compatibility of AQ table must be release 8.1.x or later

Oracle Error ORA-42023: compatibility of AQ table must be release 8.1.x or later

Oracle Error Message

ORA-42023: compatibility of AQ table must be release 8.1.x or later

Reason for the Error

An attempt was made to perform online redefinition on an AQ table that was created with compatibility prior to release 8.1.x.

Solution

Ensure that the AQ table is created with the COMPATIBLE parameter set to release 8.1.x or later before attempting online redefinition.

Share:

Leave A Reply

Your email address will not be published. Required fields are marked *

You May Also Like

Oracle Error Message CLSGN-32767: Internal error. Reason for the Error An unexpected error occurred. Solution Examine the message(s) that accompany...
Oracle Error Message CLSGN-00211: OCR batch operation failed. string Reason for the Error Setting a set of Oracle Cluster Registry...
Oracle Error Message CLSGN-00210: failed to get value for OCR key “string”. string Reason for the Error It was not...