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

ORA-01256: error in locking database file string

1 Answers  


ORA-16131: An error occurred during a Terminal Recovery of the standby.

1 Answers  


ORA-36708: (XSMXALLOC00) Variable workspace object must be dimensioned to be used by the ALLOCATE command.

1 Answers  


LSX-00294: field "~S" produced multiple hits

1 Answers  


DRG-11842: Service Unavailable

1 Answers  


PLS-00720: type 'string' has evolved

1 Answers  


NNL-00542: restart [<server_list>] : restart one or more Names servers

1 Answers  


QSM-01028: materialized view, string, is currently being refreshed

1 Answers  


ORA-21560: argument string is null, invalid, or out of range

1 Answers  


ORA-03123: operation would block

1 Answers  


TNS-00135: Missing TNS error message file

1 Answers  


NNO-00633: detected fatal delegation loop involving server "string"

1 Answers  


Categories