Oracle Error Message
ORA-31470: asynchronous change tables must contain the RSID$ column
Reason for 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’.
Solution
When creating asynchronous change tables, always specify ‘Y’ for the RSID parameter. When altering asynchronous change tables always specify ‘N’ for RSID.