ORA-12098: cannot comment on the materialized view

Answers were Sorted based on User's Feedback



ORA-12098: cannot comment on the materialized view..

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

ORA-12098: cannot comment on the materialized view..

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

Post New Answer

More Oracle Errors Interview Questions

RMAN-05511: Datafile string skipped by request

1 Answers  


ORA-01987: client os username is too long

1 Answers  


RMAN-06595: platform name 'string' does not match database platform name 'string'

1 Answers  


ORA-22982: cannot create sub-view under this view

1 Answers  


ORA-32108: max column or parameter size not specified

1 Answers  






NNL-00256: Server-generated requests now do not request forwarding

1 Answers  


PCC-02305: illegal mixing of new and old style C function declarations

1 Answers  


ORA-25197: an overflow segment already exists for the indexed-organized table

1 Answers  


QSM-01004: no query rewrite before view merging

1 Answers  


SQL-02127: Precompiler/SQLLIB version mismatch

1 Answers  


EXP-00073: dump file size too small

1 Answers  


ORA-29372: identifier string is too long; it must be less than string characters

1 Answers  


Categories