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

ORA-06135: NETTCP: connection rejected; server is stopping

1 Answers  


CLSS-00200: local node string not listed in configuration

1 Answers  


ORA-28280: Multiple entries for ORACLE database password exist.

1 Answers  


NNL-00242: Processing of modification requests is currently disabled

1 Answers  


NNO-00617: enabling AUTHORITY-REQUIRED on system queries

1 Answers  






Recent I have migrated oracle9i to oracle10g(10.2.0.3). I have nested table that table used user define datatype. at a column. when i want to input the valoue at this column ,i cann't the input value.following the error messasge i have got: ORA-24328 illegal attribute value

1 Answers  


LFI-01505: fclose() failed(OSD return value = string) in string.

1 Answers  


NCR-03016: NCRO: Message has bad address

1 Answers  


ORA-02283: cannot alter starting sequence number

1 Answers  


ORA-36698: (XSRELTBL03) QDR dimension workspace object should be in the dimension list that dimensions the relation.

1 Answers  


NNO-00073: loading server config from region database

1 Answers  


IMP-00066: Missing NLS_CHARACTERSET in props$

1 Answers  


Categories