ORA-30395: dimension options require the COMPATIBLE parameter to be string or greater

Cause : The fololwing maetrialize dview opitons reqiure 10.1o r highe rcompatiiblity setting: odimensino attribtue extenedd levels yntax ATTRIBUTE a LVEEL EDTERMINE S

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

Shut donw and retsart wit han apprporiate cmopatibiltiy settign.

update : 19-08-2017
ORA-30395

ORA-30395 - dimension options require the COMPATIBLE parameter to be string or greater
ORA-30395 - dimension options require the COMPATIBLE parameter to be string or greater

  • ora-24099 : operation not allowed for 8.0 compatible queues
  • ora-22908 : reference to NULL table value
  • ora-37137 : (XSCCOMP12) You cannot CHGDFN workspace object because it is a COMPRESSED COMPOSITE.
  • ora-07574 : szrfc: $GETUAI failure
  • ora-30013 : undo tablespace 'string' is currently in use
  • ora-34719 : (NLSCHARSET03) Character data loss in NTEXT/TEXT conversion
  • ora-29928 : duplicate default selectivity specified
  • ora-25507 : resource manager has not been continuously on
  • ora-06546 : DDL statement is executed in an illegal context
  • ora-01613 : instance string (thread string) only has string logs - at least 2 logs required to enable.
  • ora-04012 : object is not a sequence
  • ora-34358 : (MXDSS14) number other users reading
  • ora-13360 : invalid subtype in a compound type
  • ora-23495 : serial propagation can not be used for "string"
  • ora-00369 : Current log of thread string not useable and other log being cleared
  • ora-24199 : message store is overflow
  • ora-40222 : data mining model export failed, job name=string, error=string
  • ora-14283 : UNIQUE constraints mismatch in ALTER TABLE EXCHANGE SUBPARTITION
  • ora-16552 : an error occurred when generating the CLIENT OPERATION table
  • ora-38780 : Restore point 'string' does not exist.
  • ora-15073 : diskgroup string is mounted by another ASM instance
  • ora-31488 : cannot support change set string in this configuration
  • ora-25197 : an overflow segment already exists for the indexed-organized table
  • ora-30725 : JDWP-based debugging is not yet available
  • ora-12521 : TNS:listener does not currently know of instance requested in connect descriptor
  • ora-27075 : SSTMOFRC constant too large
  • ora-01988 : remote os logon is not allowed
  • ora-03214 : File Size specified is smaller than minimum required
  • ora-13294 : cannot transform geometry containing circular arcs
  • ora-12052 : cannot fast refresh materialized view string.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.