ORA-12018: following error encountered during code generation for "string"."string"

Cause : The refersh opertaions fo rthe indciated maetrialize dview colud not b eregenertaed due ot errors.

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

Correctt he probelm indictaed in teh follownig errorm essagesa nd repeta the opreation.

update : 24-09-2017
ORA-12018

ORA-12018 - following error encountered during code generation for "string"."string"
ORA-12018 - following error encountered during code generation for "string"."string"

  • ora-14097 : column type or size mismatch in ALTER TABLE EXCHANGE PARTITION
  • ora-37156 : (string)
  • ora-07215 : slsget: getrusage error.
  • ora-12814 : only one CACHE or NOCACHE clause may be specified
  • ora-23437 : template authorization already exists for user
  • ora-31510 : name uses reserved prefix CDC$
  • ora-35021 : (QFCHECK08) The EIF file definition of workspace object has some partitions that are not present in the existing Analytic Workspace object.
  • ora-38709 : Recovery Area is not enabled.
  • ora-31687 : error creating worker process string with worker id string
  • ora-09240 : smpalo: error allocating PGA memory
  • ora-02331 : cannot create constraint on column of datatype string
  • ora-06571 : Function string does not guarantee not to update database
  • ora-03128 : connection is in blocking mode
  • ora-38788 : More standby database recovery is needed
  • ora-16572 : Data Guard configuration file not found
  • ora-30940 : Cannot resolve prefix 'string' for QName node 'string'
  • ora-07217 : sltln: environment variable cannot be evaluated.
  • ora-03263 : cannot drop the first file of tablespace string
  • ora-09756 : osnpns: no port in the name server.
  • ora-30927 : Unable to complete execution due to failure in temporary table transformation
  • ora-30357 : this PL/SQL function cannot be supported for query rewrite
  • ora-31157 : Invalid Content-Type charset
  • ora-06751 : TLI Driver: bound addresses unequal
  • ora-01545 : rollback segment 'string' specified not available
  • ora-02878 : sou2o: Variable smpdidini overwritten
  • ora-19250 : XQ0030 - too many values to validate expression
  • ora-13052 : unsupported geometric type for geometry string.string
  • ora-01338 : Other process is attached to LogMiner session
  • ora-01023 : Cursor context not found (Invalid cursor number)
  • ora-16019 : cannot use string with LOG_ARCHIVE_DEST or LOG_ARCHIVE_DUPLEX_DEST
  • 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.