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



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

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

Post New Answer

More Oracle Errors Interview Questions

KUP-04016: unknown SLF status code number

1 Answers  


ORA-06044: NETDNT: connect failed, byte count quota exceeded

1 Answers  


ORA-24324: service handle not initialized

1 Answers  


DRG-11119: operation is not supported by this index type

1 Answers  


ORA-16791: Unable to check the existence of the standby redo logs

1 Answers  






ORA-32141: get method does not match the type of the parameter

1 Answers  


ORA-27005: cannot open file for async I/O on device not supporting async

1 Answers  


ORA-06539: target of OPEN must be a query

1 Answers  


ORA-16776: Health check of the log transport service failed.

1 Answers  


DRG-11307: operation cannot be performed on an index

1 Answers  


ORA-38761: thread string redo log sequence number string could not be accessed

1 Answers  


ORA-07534: scginq: $getlki unexpected return on lockid string

1 Answers  


Categories