ORA-12024: materialized view log on "string"."string" does
not have primary key columns



ORA-12024: materialized view log on "string"."string" does not have primary key..

Answer / guest

Cause: Materialized view log on the indicated table does not
have primary key information.

Action: Add primary keys to the materialized view log using
the ALTER MATERIALIZED VIEW 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-30505: system triggers should not reference a column in a WHEN clause

1 Answers  


TNS-04203: Trace Assistant Usage ERROR: Invalid options

1 Answers  


ORA-24390: Unsupported scrollable cursor operation

1 Answers  


ORA-14170: cannot specify <partition-description> clause in CREATE TABLE|INDEX

1 Answers  


ORA-24332: invalid object type

1 Answers  






ORA-30676: socket read or write failed

1 Answers  


How to resolve QSM-01108 error. I have no OR conditions in my query, but do have 9 IN conditions. The error says the max limit is 2 while I have 257 number of disjuncts. However, if I remove even a single IN condition, the query is rewritten. I cannot change my query. How can I resolve this issue?

0 Answers  


ORA-03298: cannot shrink datafile - file string is under hot backup

1 Answers  


TNS-12557: TNS:protocol adapter not loadable

2 Answers  


TNS-12223: TNS:internal limit restriction exceeded

1 Answers  


TNS-00225: Unable to bequeath connection to pump

1 Answers  


ORA-07209: sfofi: file size limit was exceeded.

1 Answers  


Categories