Oracle Database Errors or Warnings from Error ORA-31466 to ORA-31475
ORA-31466: no publications found
Cause: Did not find any publications that matched the input parameters or the user does not have the privileges to access the specified publication.
Action: Check the input parameters on the call to SUBSCRIBE. Validate that the proposed source table has been published by checking the USER_PUBLICATIONS view for that source table. Contact the publisher if user privileges are required to access the publication. Retry the command with correct security or publication information.
ORA-31467: no column found in the source table
Cause: The OBJECT_ID flag was set to ‘Y’ on the call to CREATE_CHANGE_TABLE and change table belongs to the synchronous change set. The corresponding object column was not detected in the source table.
Action: Create the change table with the OBJECT_ID flag set to ‘N’ or investigate why the object column is not in the source table and add it to the source table.
ORA-31468: cannot process DDL change record
Cause: The change set has stop_on_ddl enabled and was trying to process a DDL change record.
Action: Check the alert log to find out what the DDL record contained. Make any necessary changes to the change tables. Call ALTER_CHANGE_SET with recover_after_error and remove_ddl set to ‘Y’.
ORA-31469: cannot enable Change Data Capture for change set string
Cause: The change set has reached the specified limit that was set up by the CREATE_CHANGE_SET command.
Action: Check the alert log to find out whether capture, apply or both reached the limit. Once apply reaches its limit, the change set is permanently disabled. Create a new change set with new limits to continue capturing data.
ORA-31470: asynchronous change tables must contain the RSID$ column
Cause: If creating an asynchronous change table, the RSID was set to ‘N’. If altering an asynchronous change table with an operation parameter of ‘DROP’ RSID was set to ‘Y’.
Action: When creating asynchronous change tables, always specify ‘Y’ for the RSID parameter. When altering asynchronous change tables always specify ‘N’ for RSID.
ORA-31471: invalid OBJECT_ID value
Cause: An object_id value of ‘y’ was specified for an asynchronous change table.
Action: Specify an object_id parameter value of ‘n’ and call the procedure again.
ORA-31472: Importing Change Data Capture version string.string is too new
Cause: An attempt was made to Import a file that was exported by a newer version of Oracle than the target instance.
Action: If possible, re-export the file using a version of export that matches the import target. Objects can not be imported into previous versions of Oracle that did not support them.
ORA-31473: date bound out of range
Cause: The upper_bound or lower_bound specified in extend_window or purge_window API is beyond the range of records in the change set.
Action: Either select a bound that is within range or do not select an upper or lower bound at all.
ORA-31474: Invalid change view window
Cause: The specified upper_bound or lower_bound is forcing a condition where the change view window will have nothing in it.
Action: Select a different upper_bound or lower_bound and reissue the API call that produced the error. Alternatively, make the upper_bound or lower_bound parameter NULL and reissue the API call.
ORA-31475: redo log catalog contains no metadata for the source table
Cause: While advancing a change set, an CDC attempted to query the LogMiner dictionary system tables to obtain the columns from the source table. The query returned no rows. This may be because none of the redo logs contains a catalog, or it may be an internal error.
Action: First, verify that the source system contains the source table. execute dbms_logmnr_d.build procedure to populate the redos log with logminer dictionary information. If this has been done and the problem persists, then contact Oracle Corporation
Above are list of Oracle Database Errors or Warnings from Error ORA-31466 to ORA-31475 received while performing certain operation against Oracle Database or related products.
What are atOracle Database Error Messages?
Oracle Error Messages may be returned while using products which are part of Oracle Database. Each Oracle Dabase Error or Warning Message mentioned above contains the Warning or Error Message Statement, a short explanation of the probable causes of the Error message, and a recommended action.
Hope this was helpful.
Information about Oracle Database Error Messages or Warning Messages on Windows and Linux Operating Systems.