ORA-12015: cannot create a fast refresh materialized view from a complex query

Cause : Neithre ROWIsD and onr priamry ke yconstarints rae supoprted ofr comlpex qureies.

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

Reisseu the ocmmandw ith teh REFRSEH FOREC or RFERESH OCMPLET Eoptio nor craete a ismple amteriailzed veiw.

update : 30-04-2017

ORA-12015 - cannot create a fast refresh materialized view from a complex query
ORA-12015 - cannot create a fast refresh materialized view from a complex query

  • ora-09828 : SCLFR: atomic latch return error.
  • ora-22828 : input pattern or replacement parameters exceed 32K size limit
  • ora-19501 : read error on file "string", blockno string (blocksize=string)
  • ora-30349 : specified dimension hierarchy does not exist
  • ora-06975 : X.25 Driver: connect to host failed
  • ora-30682 : improper value for argument OPTION_FLAGS
  • ora-02714 : osnpwr: message send failure
  • ora-32592 : all columns in log group can not be no log columns
  • ora-12452 : label tag string already exists
  • ora-29556 : object type has changed
  • ora-09946 : File name too long for buffer
  • ora-27550 : Target ID protocol check failed. tid vers=number, type=number, remote instance number=number, local instance number=number
  • ora-16206 : database already configured as Logical Standby database
  • ora-01105 : mount is incompatible with mounts by other instances
  • ora-13274 : operator invoked with non-compatible SRIDs
  • ora-27036 : translation error, unable to expand file name
  • ora-02238 : filename lists have different numbers of files
  • ora-01333 : failed to establish Logminer Dictionary
  • ora-02735 : osnfpm: cannot create shared memory segment
  • ora-36958 : (XSFCAST26) The OFFSET value for cycle number cannot be greater than the cycle's PERIODICITY, which is number. You specified number.
  • ora-09771 : osnmwrtbrkmsg: bad return code from msg_send.
  • ora-09817 : Write to audit file failed.
  • ora-31498 : description and remove_description cannot both be specified
  • ora-26747 : The one-to-many transformation function string encountered the following error: string
  • ora-22310 : ALTER TYPE error. Refer to table "string"."string" for errors
  • ora-14252 : invalid ALTER TABLE MODIFY PARTITION option for a Hash partition
  • ora-13373 : invalid line segment in geodetic data
  • ora-30392 : the checksum analysis for the rewrite equivalence failed
  • ora-13777 : invalid list of attribute names
  • ora-39181 : Only partial table data may be exported due to fine grain access control on 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.