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-13109: spatial table string exists

1 Answers  


ORA-32144: Cannot perform operation on a null interval

1 Answers  


ORA-04073: column list not valid for this trigger type

1 Answers  


QSM-00786: the name string is invalid for directive string

1 Answers  


ORA-29807: specified operator does not exist

1 Answers  






RMAN-02000: wrong message file version (msg number not found)

1 Answers  


PCB-00556: Unrecoverable error. Fix previous errors and re-precompile

1 Answers  


ORA-08462: raw buffer contains invalid decimal data

1 Answers  


PCC-02116: You must specify a file extension using the HEADER option

1 Answers  


ORA-25133: duplicate SINGLE TABLE option specified

1 Answers  


QSM-01025: materialized view, string, not found

1 Answers  


PCB-00902: Unable to read message file, facility PCB

1 Answers  


Categories