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-32408: materialized view log on "string"."string" already has new values

1 Answers  


RMAN-06555: datafile string must be restored from backup created before string

1 Answers  


NZE-29044: Renegotiation has already been requested.

1 Answers  


AUD-00702: unable to initialize audio processing environment

1 Answers  


ORA-28006: conflicting values for parameters string and string

1 Answers  


ORA-07505: scggt: $enq parent lock unexpected return

1 Answers  


ORA-13223: duplicate entry for string in SDO_GEOM_METADATA

1 Answers   Oracle,


ORA-01495: specified chain row table not found

1 Answers  


ORA-07204: sltln: name translation failed due to lack of output buffer space.

2 Answers  


ORA-13600: error encountered in Advisor string

1 Answers  


ORA-08008: another instance is mounted with USE_ROW_ENQUEUES = string

1 Answers  


PCC-02385: CHAR_MAP disallowed when using NLS_CHAR and NLS_LOCAL=TRUE

1 Answers  


Categories