ORA-12098: cannot comment on the materialized view

Cause : An attmept wasm ade toi ssue aC OMMENTO N TABL Estatemnet on am ateriailzed viwe.

Action - How to fix it : DBA Scripts :: www.high-oracle.com/scripts

Issue aCOMMEN TON MATREIALIZE DVIEW sattementi nstead.

update : 20-08-2017
ORA-12098

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

  • ora-23410 : materialized view "string"."string" is already in a refresh group
  • ora-12636 : Packet send failed
  • ora-12699 : Native service internal error
  • ora-06815 : TLI Driver: could not link SPX and IPX streams
  • ora-37080 : Advice requested for hierarchy with too many levels
  • ora-28044 : unsupported directory type
  • ora-16210 : Logical standby coordinator process terminated with error
  • ora-10564 : tablespace string
  • ora-13360 : invalid subtype in a compound type
  • ora-36273 : (XSCGMDLAGG12) Dimension workspace object appears more than once in the QDR.
  • ora-34363 : (MXDSS13) number other user writing
  • ora-24355 : attempt to store a negative number in an Unsigned Display type.
  • ora-02066 : missing or invalid DISPATCHERS text
  • ora-36991 : (XSRELGID08) The level relation and level order valueset provide inconsistent level mappings.
  • ora-27300 : OS system dependent operation:string failed with status: string
  • ora-36167 : (XSAGGRFORM) workspace object is an illegal AGGMAP for aggregating a FORMULA.
  • ora-02737 : osnpcl: cannot tell orapop to exit
  • ora-02042 : too many distributed transactions
  • ora-30980 : Invalid Input.
  • ora-26716 : message limit reached
  • ora-12422 : max policies exceeded
  • ora-13384 : error in network schema: string
  • ora-01695 : error converting rollback segment string to version 8.0.2
  • ora-13450 : GeoRaster metadata layerInfo error
  • ora-12736 : Instant Client Light: unsupported server national character set string
  • ora-01774 : Dump undo option specified more than once
  • ora-32640 : FOR LIKE loops are not allowed for multi-byte character types
  • ora-31007 : Attempted to delete non-empty container string/string
  • ora-13412 : invalid scale parameter
  • ora-12024 : materialized view log on "string"."string" does not have primary key columns
  • Oracle Database Error Messages



    Oracle Database High Availability Any organization evaluating a database solution for enterprise data must also evaluate the High Availability (HA) capabilities of the database. Data is one of the most critical business assets of an organization. If this data is not available and/or not protected, companies may stand to lose millions of dollars in business downtime as well as negative publicity. Building a highly available data infrastructure is critical to the success of all organizations in today's fast moving economy.

    Well, the reason for above error is that i have taken the above script from a 11g database and running it on 10g database. 11g has bring some changes in password management. Below code is executed on 11g and user created successfully, which is expected result.