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

QSM-02152: subquery or named view in FROM list even after view merging

1 Answers  


ORA-14270: table is not partitioned by Range or Hash or List method

1 Answers  


ORA-36720: (XSALLOC01) To be used with ALLOCATE, your AGGMAP workspace object must be defined with the ALLOCMAP command.

1 Answers  


ORA-24038: RETRY_DELAY and MAX_RETRIES cannot be used for a 8.0 compatible multiple consumer queue

1 Answers  


RMAN-06015: error while looking up datafilecopy name: string

1 Answers  


DRG-11207: user filter command exited with status string

1 Answers  


ORA-30753: column or table string is substitutable

1 Answers  


ORA-16134: invalid MANAGED recovery FINISH option

1 Answers  


PLS-00717: method 'string' does not have matching signature among existing methods

1 Answers  


TNS-01001: start [<listener_name>] : start listener

1 Answers  


ORA-09778: snynfyport: failure allocating the notify port.

1 Answers  


ORA-00824: cannot set sga_target due to existing internal settings

1 Answers  


Categories