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

ORA-22333: cannot reset type "string"."string" due to invalid dependent types and tables

1 Answers  


KUP-04070: field string referenced by column transform string not found

1 Answers  


ORA-36872: (XSTFDSC02) Column type specifier cannot be used when the table function data type is specified.

1 Answers  


ORA-39304: during sync/swap, object "string" conflicts: "string"

1 Answers  


LFI-00133: Trying to create file string that already exists.

1 Answers  






SQL*Loader-00653: XML data set to NULL in column string, row number, table string

1 Answers  


ORA-30489: Cannot have more than one rollup/cube expression list

1 Answers  


ORA-01653: unable to extend table string.string by string in tablespace string

1 Answers  


NCR-00003: NCR: Initialization failure

1 Answers  


ORA-13444: GeoRaster metadata SRS error

1 Answers  


ORA-38611: FI input cursor's item type is not supported

1 Answers  


ORA-30946: XML Schema Evolution warning: temporary tables not cleaned up

1 Answers  


Categories