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-13503: Creating SYSAUX tablespace with invalid attributes

1 Answers  


ORA-15022: parameter length 'string' is longer than string

1 Answers  


NZE-29159: Unable to read library.

1 Answers  


ORA-24044: source string and destination string object types do not match

1 Answers  


NNO-00122: invalid name, data ignored: entry: string

1 Answers  






LCD-00206: positional parameter entered after keyword [string]

1 Answers  


ORA-09773: osnmgetdatmsg: message from host had incorrect message type

1 Answers  


LPX-00279: invalid no_proxy "~s"

1 Answers  


ORA-15031: disk specification 'string' matches no disks

1 Answers  


SQL*Loader-00459: error fetching numeric value for sequence on column (string)

1 Answers  


ORA-13424: the GeoRaster object is not spatially referenced

1 Answers  


TNS-12590: TNS:no I/O buffer

1 Answers  


Categories