ORA-12082: "string"."string" cannot be index organized

Cause : An attempt was made to create an index-organized materialized aggregate view or an index-organized updatable ROWID materialized view. This is not supported.

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

Try to create the materialized view without the index organization clause.

update : 27-04-2017
ORA-12082

ORA-12082 - "string"."string" cannot be index organized
ORA-12082 - "string"."string" cannot be index organized

  • ora-02333 : cannot create constraints on attributes of this column
  • ora-12151 : TNS:received bad packet type from network layer
  • ora-22335 : The client cannot work with an altered type
  • ora-39166 : Object string was not found.
  • ora-26670 : STREAMS option requires COMPATIBLE parameter to be string or higher
  • ora-22330 : cannot alter a type that is not valid
  • ora-01082 : 'row_locking = always' requires the transaction processing option
  • ora-26709 : Streams RFS restart
  • ora-34489 : (MXMAINT06) You cannot maintain workspace object because it is a SURROGATE.
  • ora-32128 : setDataBuffer called after fetch has started
  • ora-32109 : invalid column or parameter position
  • ora-13844 : no new SQL profile name or category specified.
  • ora-02314 : illegal use of type constructor
  • ora-39079 : unable to enqueue message string
  • ora-16202 : Skip procedure requested to replace statement
  • ora-16951 : Too many bind variables supplied for this SQL statement.
  • ora-28579 : network error during callback from external procedure agent
  • ora-02194 : event specification syntax error string (minor error string) near 'string'
  • ora-00396 : error string required fallback to single-pass recovery
  • ora-01280 : Fatal LogMiner Error.
  • ora-22893 : constraint can be specified only for REF columns
  • ora-03246 : Invalid block number specified
  • ora-16757 : resource guard could not get property
  • ora-29522 : authorization error for referenced name string.string
  • ora-10902 : disable seghdr conversion for ro operation
  • ora-13200 : internal error [string] in spatial indexing.
  • ora-17612 : Failed to discover Oracle Disk Manager library, return value string
  • ora-10919 : Default temporary tablespace group must have at least one tablespace
  • ora-16236 : Logical Standby metadata operation in progress
  • ora-38790 : BEFORE must be specified with RESETLOGS
  • 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.