ORA-12098: cannot comment on the materialized view
Answers were Sorted based on User's Feedback
Answer / guest
Cause: An attempt was made to issue a COMMENT ON TABLE
statement on a materialized view.
Action: Issue a COMMENT ON MATERIALIZED VIEW statement instead.
Please add more information about this Error
| Is This Answer Correct ? | 0 Yes | 0 No |
Answer / andrew
I have posted an explanation here:
http://international-dba.blogspot.co.uk/2012/06/comments-on-materialized-views.html
If it isn't clear, feel free to add a comment at the end.
| Is This Answer Correct ? | 0 Yes | 0 No |
ORA-13601: The specified Advisor string does not exist.
NNL-00984: Name-to-hint translations failed: number
ORA-25105: RECOVERABLE option can only be used with ALTER INDEX REBUILD
ORA-19036: Invalid query result set in newContextFromHierarchy()
SQL-02157: Source or destination lob is invalid
ORA-38423: Attribute set created from an ADT may not be extended.
NID-00133: Database should have only consistent datafiles
ORA-14169: invalid ALTER TABLE MODIFY SUBPARTITION option
ORA-14074: partition bound must collate higher than that of the last partition
ORA-27198: skgfpvl: sbtpcvalidate returned error
ORA-19768: USING clause only valid with ENABLE CHANGE TRACKING
ORA-09291: sksachk: invalid device specified for archive destination