ORA-31470: asynchronous change tables must contain the RSID$
column
- 1 Answers
- 2849 Views
- I also Faced
- E-Mail Answers
Answer / guest
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.
Please add more information about this Error
| Is This Answer Correct ? | 0 Yes | 1 No |
ORA-00213: cannot reuse controlfile; old file size string, string required
ORA-23318: a ddl failure has occurred
ORA-38446: Error with embedded ADT "string" in the attribute set.
ORA-09760: osnpui: cannot send break message
TNS-12593: TNS:no registered connection
TNS-00015: INTCTL: error while closing terminal input channel
KUP-02004: quoted string too big
ORA-12040: master rollback segment option not support by master site string
ORA-04097: DDL conflict while trying to drop or alter a trigger
ORA-01910: TABLES keyword expected
ORA-16163: LGWR network server host attach error
PLS-00503: RETURN <value> statement required for this return from function
Oracle Errors 
