ORA-23414: materialized view log for "string"."string" does
not record rowid values



ORA-23414: materialized view log for "string"."string" does not record rowid va..

Answer / guest

Cause: A rowid materialized view is being fast refreshed,
but the materialized view log does not record rowid information.

Action: Use the CREATE MATERIALIZED VIEW LOG...ADD ROWID
command to begin recording rowid information in the
materialized view log.

Please add more information about this Error

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Oracle Errors Interview Questions

ORA-01634: rollback segment number 'string' is about to go offline

1 Answers  


ORA-07211: slgcs: gettimeofday error, unable to get wall clock.

1 Answers  


ORA-12853: insufficient memory for PX buffers: current stringK, max needed stringK

1 Answers  


ORA-06790: TLI Driver: poll failed

1 Answers  


KUP-04083: no directory object specified in LOBFILE clause for column string

1 Answers  






ORA-01781: UNRECOVERABLE cannot be specified without AS SELECT

1 Answers  


KUP-04002: error getting file size for file string

1 Answers  


ORA-24203: operation failed, queue table string.string has errors

1 Answers  


ORA-28540: internal result set error

1 Answers  


PCB-00006: Userid only used when SQLCHECK=FULL, userid ignored.

1 Answers  


SQL*Loader-00116: Error prompting for password

1 Answers  


IMG-00822: area queue reset failed

1 Answers  


Categories