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 : 24-07-2017

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

  • ora-08261 : ora_addr: cannot find name in nameserver
  • ora-02720 : osnfop: shmat failed
  • ora-02031 : no ROWID for fixed tables or for external-organized tables
  • ora-08275 : Environment variable unset
  • ora-34296 : (MXDCL36) A NUMBER dimension must be defined with a fixed precision and scale, using the form NUMBER(precision) or NUMBER(precision, scale).
  • ora-35282 : (SNSYN166) The format of the AGGREGATE function is: AGGREGATE(varname USING aggmap-name [COUNTVAR intvar-name] [FORCECALC])
  • ora-25441 : duplicate column value for table alias: string
  • ora-39216 : object type "string"."string" hashcode mismatch
  • ora-08175 : discrete transaction restriction violated (string)
  • ora-38497 : Expression Filter index does not exist
  • ora-22850 : duplicate LOB storage option specificed
  • ora-30104 : 'string' is not a legal integer for 'string'
  • ora-12602 : TNS: Connection Pooling limit reached
  • ora-03129 : the next piece to be inserted is required
  • ora-30077 : illegal casting between specified datetime types
  • ora-39092 : unable to set SCN metadata for object "string.string" of type string
  • ora-32339 : cannot alter materialized view with the PMOP
  • ora-37030 : (XSMLTMAINT01) You cannot maintain workspace object because it is not ACQUIRED.
  • ora-25110 : NOSORT may not be used with a bitmap index
  • ora-29382 : validation of pending area failed
  • ora-29252 : collection does not contain elements at index locations in call to dbms_sql.bind_array
  • ora-32161 : Cannot perform piecewise fetch
  • ora-07266 : sppst: invalid process number passed to sppst.
  • ora-31013 : Invalid XPATH expression
  • ora-38792 : encountered unknown flashback record from release string
  • ora-07227 : rtneco: unable to set noecho mode.
  • ora-12732 : invalid interval value in regular expression
  • ora-31424 : change table has active subscriptions
  • ora-23480 : Column string is not a top-level column of "string"."string".
  • ora-00292 : parallel recovery feature not installed
  • 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.