How to fix the Oracle error ORA-31470: asynchronous change tables must contain the RSID$ column?

In this post, you’ll learn more about the Oracle ErrorORA-31470: asynchronous change tables must contain the RSID$ column with the details on why you receive this error and the possible solution to fix it.

Oracle Error Description

ORA-31470: asynchronous change tables must contain the RSID$ column

Reason for the Error ORA-31470: asynchronous change tables must contain the RSID$ column

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’.

How to fix the Error ORA-31470: asynchronous change tables must contain the RSID$ column ?

You can fix this error in Oracle by following the below steps

When creating asynchronous change tables, always specify ‘Y’ for the RSID parameter. When altering asynchronous change tables always specify ‘N’ for RSID.