ORA-23435: cannot create an updatable ROWID materialized
view with LOB columns



ORA-23435: cannot create an updatable ROWID materialized view with LOB columns..

Answer / guest

Cause: The propagation of LOB data from materialized view
sites to the master site requires a primary key on the
replicated table. Thus updatable ROWID materialized views
that contain LOB columns are not supported.

Action: Create a primary key materialized view instead of a
ROWID materialized view. If the materialized view already
exists, it can be converted to a primary key materialized
view using the ALTER MATERIALIZED VIEW DDL command.

Please add more information about this Error

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Oracle Errors Interview Questions

RMAN-05501: aborting duplication of target database

1 Answers  


ORA-02001: user SYS is not permitted to create indexes with freelist groups

1 Answers  


LSX-00200: element "~S" not empty

1 Answers  


PCC-02304: invalid declaration of C function

1 Answers  


ORA-13853: Tracing for service (module/action) string is already enabled

1 Answers  






RMAN-06900: WARNING: unable to generate V$RMAN_STATUS or V$RMAN_OUTPUT row

1 Answers  


TNS-00015: INTCTL: error while closing terminal input channel

1 Answers  


NNL-00990: DEFAULT-FORWARDERS-ONLY mode: string

1 Answers  


TNS-12524: TNS:listener could not resolve HANDLER_NAME given in connect descriptor

1 Answers  


ORA-09747: pw_detachPorts: server call pws_detach failed.

1 Answers  


ORA-31011: XML parsing failed

1 Answers  


NNL-00409: data type is "string"

1 Answers  


Categories