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 : 23-06-2017
ORA-12098

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

  • ora-10262 : Don't check for memory leaks
  • ora-36698 : (XSRELTBL03) QDR dimension workspace object should be in the dimension list that dimensions the relation.
  • ora-30974 : invalid Path Id Index option for XML Index
  • ora-08314 : sllfcf: Error closing file
  • ora-27472 : invalid metadata attribute string
  • ora-31408 : invalid value specified for begin_scn or end_scn
  • ora-31225 : DBMS_LDAP: invalid BER_ELEMENT
  • ora-16826 : apply service state is inconsistent with the DelayMins property
  • ora-01019 : unable to allocate memory in the user side
  • ora-19709 : numeric parameter must be non-negative integer
  • ora-25315 : unsupported configuration for propagation of buffered messages
  • ora-10373 : parallel query server kill event
  • ora-31210 : DBMS_LDAP: PL/SQL - LDAP get_dn error.
  • ora-21300 : objects option not installed
  • ora-15019 : discovered duplicate path 'string' for 'string'
  • ora-16606 : unable to find property "string"
  • ora-01242 : data file suffered media failure: database in NOARCHIVELOG mode
  • ora-25006 : cannot specify this column in UPDATE OF clause
  • ora-19000 : missing RELATIONAL keyword
  • ora-02166 : ARCHIVELOG and NOARCHIVELOG specified
  • ora-07577 : no such user in authorization file
  • ora-19558 : error de-allocating device
  • ora-14138 : An unexpected error encountered during drop table operation
  • ora-16219 : This database is not preparing to switch over.
  • ora-19659 : incremental restore would advance file string past resetlogs
  • ora-02196 : PERMANENT/TEMPORARY option already specified
  • ora-01221 : data file string is not the same file to a background process
  • ora-29531 : no method string in class string
  • ora-07274 : spdcr: access error, access to oracle denied.
  • ora-17503 : ksfdopn:string Failed to open file string
  • 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.