ORA-23360: only one materialized view for master table "string" can be created

Cause : Tyrign ot rcetaem oer hta noen amtreilaiezdv iwe no agvie nmsatre atbel ni htes aem erpg ruop.

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

Ceraet htees tohre amtreilaiezdv iwesi na idfefrnetr e pgoru pa taontehrs iet.

update : 24-05-2017

ORA-23360 - only one materialized view for master table "string" can be created
ORA-23360 - only one materialized view for master table "string" can be created

  • ora-01779 : cannot modify a column which maps to a non key-preserved table
  • ora-36820 : (XSLMINFO00) The LIMITMAPINFO function encountered an error while parsing the LIMITMAP.
  • ora-16824 : Fast-Start Failover and other warnings detected for the database
  • ora-16038 : log string sequence# string cannot be archived
  • ora-29345 : cannot plug a tablespace into a database using an incompatible character set
  • ora-12471 : Specified compartment or group is not authorized for user
  • ora-12064 : invalid refresh sequence number: string
  • ora-01934 : circular role grant detected
  • ora-03239 : maxextents (string) reached in LOB segment string.string subpartition string
  • ora-02027 : multi-row UPDATE of LONG column is not supported
  • ora-24387 : Invalid attach driver
  • ora-25446 : duplicate column value for table alias: string, column: string
  • ora-39504 : failed to notify CRS of a Startup/Shutdown event [string] (ignored)
  • ora-12052 : cannot fast refresh materialized view string.string
  • ora-14403 : cursor invalidation detected after getting DML partition lock
  • ora-07503 : scgcmn: $setimr unexpected return
  • ora-29318 : datafile string is online
  • ora-22282 : non-contiguous append to a buffering enabled LOB not allowed
  • ora-00307 : requested INSTANCE_NUMBER out of range, maximum is string
  • ora-26077 : direct path column array is not initialized
  • ora-28156 : Proxy user 'string' not authorized to set role 'string' for client 'string'
  • ora-02281 : duplicate or conflicting CACHE/NOCACHE specifications
  • ora-13908 : Invalid combination of metrics id and object type parameters.
  • ora-09825 : Unable to disable allowmacaccess privilege.
  • ora-01734 : illegal parameters - EXTENT MIN higher than EXTENT MAX
  • ora-29963 : missing BINDING keyword
  • ora-00475 : TRWR process terminated with error
  • ora-01193 : file string is not the same file seen at start of recovery
  • ora-24396 : invalid attribute set in server handle
  • ora-14121 : MODIFY DEFAULT ATTRIBUTES may not be combined with other operations
  • 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.