Oracle Solution for Error ora-31470

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

What triggered the Error:

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

What should we do to fix it:

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