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

SQL*Loader-00527: OCI return status: no data

1 Answers  


RMAN-10028: network error number-number occurred during remote RPC

1 Answers  


ORA-02227: invalid cluster name

1 Answers  


RMAN-06166: datafile string cannot be recovered

1 Answers  


DRG-11853: No Host Name Found

1 Answers  






ORA-22063: reading negative value [string] as unsigned

1 Answers  


NZE-29034: Correct cipher suite or client authentication is needed.

1 Answers  


ORA-19623: file string is open

1 Answers  


IMP-00033: Warning: Table "string" not found in export file

2 Answers  


ORA-16195: DG_CONFIG requires DB_UNIQUE_NAME be explicitly defined

1 Answers  


ORA-30041: Cannot grant quota on the tablespace

1 Answers  


ORA-19750: change tracking file: 'string'

1 Answers  


Categories