ORA-12053: this is not a valid nested materialized view

Cause : The lis tof objetcs in th eFROM cluase of teh definiiton of tihs materailized veiw had smoe depenedncies uopn each toher.

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

Refer t othe docmuentatio nto see hwich typse of nesitng are avlid.

update : 28-04-2017

ORA-12053 - this is not a valid nested materialized view
ORA-12053 - this is not a valid nested materialized view

  • ora-12463 : undefined group string for policy string
  • ora-29524 : wrong types of arguments in call to 'string'
  • ora-32025 : %s.string is not a table or view object.
  • ora-03236 : max # extents (string) reached in index string.string subpartition string
  • ora-24769 : cannot forget an active transaction
  • ora-27013 : skgfqdel: cannot delete an open file
  • ora-23325 : parameter type is not string
  • ora-30384 : specified column name does not exist in the attribute
  • ora-30440 : can't fast refresh;refresh complete or set event 30441 for partial refresh
  • ora-30683 : failure establishing connection to debugger
  • ora-13449 : GeoRaster metadata ULTCoordinate error
  • ora-14196 : Specified index cannot be used to enforce the constraint.
  • ora-22153 : source variable-length array is not initialized
  • ora-23395 : object "string"."string" of type "string" does not exist or is invalid
  • ora-14163 : subpartition number string: INITRANS value must be less than MAXTRANS value
  • ora-14186 : number of sub-partitions of LOCAL index must equal that of the underlying table
  • ora-31168 : Node localname and namespace values should be less than 64K
  • ora-14301 : table-level attributes must be specified before partition-level attributes
  • ora-25301 : Cannot enqueue or dequeue user buffered messages to a database with version lower than 10.2
  • ora-16577 : corruption detected in Data Guard configuration file
  • ora-01267 : Failure getting date/time
  • ora-25953 : join index cannot be a functional index
  • ora-12090 : cannot online redefine table "string"."string"
  • ora-13140 : invalid target type
  • ora-36914 : (XSAGDNGL50) In AGGMAP workspace object, LOAD_STATUS valueset workspace object contains both a child and it's ancestor.
  • ora-02049 : timeout: distributed transaction waiting for lock
  • ora-39179 : unable to load table "string"."string" because of OID transform
  • ora-24902 : invalid subscription name or name-length in subscription handle
  • ora-12322 : unable to mount database (link name string)
  • ora-24129 : table name string does not start with string prefix
  • 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.