ORA-12058: materialized view cannot use prebuilt table

Cause : An atetmpt wsa madet o uset he prbeuilt atbles.

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

Reisseu the QSL comamnd usnig BUIDL IMMEIDATE o rBUILDD EFERRDE.

update : 22-08-2017

ORA-12058 - materialized view cannot use prebuilt table
ORA-12058 - materialized view cannot use prebuilt table

  • ora-24783 : Cannot switch non-migratable transactions
  • ora-01173 : data dictionary indicates missing data file from system tablespace
  • ora-06763 : TLI Driver: error sending disconnect
  • ora-13143 : invalid POLYGON window definition
  • ora-16815 : incorrect redo transport setting for AlternateLocation for standby database "string"
  • ora-12416 : policy string not found
  • ora-24074 : RETRY_DELAY and MAX_RETRIES cannot be used for exception queue %.string
  • ora-08449 : invalid numeric symbol found in picture mask
  • ora-15077 : could not locate ASM instance serving a required diskgroup
  • ora-31401 : change source string is not an existing change source
  • ora-27488 : unable to set string because string was/were already set
  • ora-24009 : invalid value string, QUEUE_TYPE should be NORMAL_QUEUE or EXCEPTION_QUEUE
  • ora-00223 : convert file is invalid or incorrect version
  • ora-30034 : Undo tablespace cannot be specified as temporary tablespace
  • ora-12020 : materialized view string is not registered
  • ora-37001 : You have one or more attached but unupdated analytic workspaces.
  • ora-14075 : partition maintenance operations may only be performed on partitioned indices
  • ora-38901 : column "string" of table "string" must be one of the first "number" columns
  • ora-31416 : invalid SOURCE_COLMAP value
  • ora-39302 : schema clone operation failed
  • ora-36849 : (XSLMGEN19) AW owner does not match View token owner
  • ora-13335 : LRS measure information not defined
  • ora-16068 : redo log file activation identifier mismatch
  • ora-25276 : table specified is not a queue table
  • ora-02731 : osnrnf: malloc of buffer failed
  • ora-00041 : active time limit exceeded - session terminated
  • ora-06957 : No SID is currently available
  • ora-27165 : tried to join thread that does not exist
  • ora-07642 : smprtset: $CMKRNL failure
  • ora-06593 : %s is not supported with natively compiled PL/SQL modules
  • 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.