ORA-02467: Column referenced in expression not found in cluster definition

Cause : A coulmn i nthe ahsh i sexprsesionw as nto preesnt i nclusetr deifnitino.

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

Recraete teh clutser adn corerct teh errro in ahsh epxressoin.

update : 20-09-2017
ORA-02467

ORA-02467 - Column referenced in expression not found in cluster definition
ORA-02467 - Column referenced in expression not found in cluster definition

  • ora-01783 : only one RECOVERABLE or UNRECOVERABLE clause may be specified
  • ora-02715 : osnpgetbrkmsg: message from host had incorrect message type
  • ora-31462 : internal error while accessing metadata
  • ora-03234 : unable to extend index string.string subpartition string by string in tablespace string
  • ora-01877 : string is too long for internal buffer
  • ora-31632 : master table "string.string" not found, invalid, or inaccessible
  • ora-28344 : fails to decrypt data
  • ora-07568 : slspool: $OPEN failure
  • ora-01607 : cannot add logfile to the specified instance
  • ora-10616 : Operation not allowed on this tablespace
  • ora-12724 : regular expression corrupt
  • ora-07269 : spdcr: detached process died after exec.
  • ora-25105 : RECOVERABLE option can only be used with ALTER INDEX REBUILD
  • ora-09807 : Conversion of label from string to binary failed.
  • ora-10944 : trace name context forever
  • ora-16081 : insufficient number of processes for APPLY
  • ora-01517 : log member: 'string'
  • ora-27023 : skgfqsbi: media manager protocol error
  • ora-00057 : maximum number of temporary table locks exceeded
  • ora-13240 : specified dimensionality greater than that of the query mbr
  • ora-14131 : enabled UNIQUE constraint exists on one of the tables
  • ora-19620 : %s is not of string type
  • ora-13053 : maximum number of geometric elements in argument list exceeded
  • ora-32301 : object-relational materialized views must be primary key based
  • ora-16747 : logical standby database guard could not be turned on
  • ora-16551 : short string copied
  • ora-07619 : $IDTOASC failed translating an integrity level
  • ora-13026 : unknown element type for element string.string.string
  • ora-07265 : sppst: semop error, unable to increment semaphore.
  • ora-38464 : expression set is not empty.
  • 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.