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

TNS-00124: Internal error - Unable to create empty address

1 Answers  


DRG-12422: write to client failed

1 Answers  


ORA-37116: OLAP API table function error: (string)

1 Answers  


ORA-00608: testing error [string] [string] [string] [string] [string]

1 Answers  


RMAN-05002: aborting point-in-time tablespace recovery

1 Answers  






QSM-01107: Partition Containment Tracking (PCT) rewrite is not allowed

1 Answers  


ORA-16032: parameter string destination string cannot be translated

1 Answers  


ORA-31477: could not detach LogMiner session during cleanup

1 Answers  


QSM-02128: does not meet the requirements of a primary key mv

1 Answers  


ORA-26063: Can not flashback to specified SCN value - Wrap: string Base: string.

1 Answers  


SQL*Loader-00107: Invalid maximum number of discards

1 Answers  


ORA-13767: End snapshot ID must be greater than or equal to begin snapsho ID.

1 Answers  


Categories