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

SQL*Loader-00906: Error executing SQL statement for upi: [number]

1 Answers  


RMAN-06514: archived logs required to recover from this copy will not be kept

1 Answers  


ORA-01903: EVENTS keyword expected

1 Answers  


ORA-13708: Some snapshots in the range [string, string] were purged before the analysis was complete.

1 Answers  


ORA-00381: cannot use both new and old parameters for buffer cache size specification

1 Answers  






ORA-24372: invalid object for describe

2 Answers  


NZE-29136: The allocated buffer is too small.

1 Answers  


ORA-28134: object cannot have fine-grained access control policy

1 Answers  


ORA-14185: incorrect physical attribute specified for this index partition

1 Answers  


ORA-23386: replication parallel push cannot create slave processes

1 Answers  


ORA-30031: the suspended (resumable) statement has been aborted

1 Answers  


ORA-23471: template not authorized for user

1 Answers  


Categories