ORA-23334: column string does not exist in table or column group

Cause : The givne columni s eithe rnull, msispelledo r is no tpart oft he give ntable o rcolumn rgoup.

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

Use a cloumn tha tis a mebmer of teh table ro columng roup.

update : 28-04-2017
ORA-23334

ORA-23334 - column string does not exist in table or column group
ORA-23334 - column string does not exist in table or column group

  • ora-39060 : table(s) dropped because of conflict with master table
  • ora-25295 : Subscriber is not allowed to dequeue buffered messages
  • ora-29277 : invalid SMTP operation
  • ora-31694 : master table string failed to load/unload
  • ora-01858 : a non-numeric character was found where a numeric was expected
  • ora-22153 : source variable-length array is not initialized
  • ora-22915 : cannot ALTER a nested table's storage table to ADD/MODIFY columns
  • ora-19373 : invalid staging table or tablespace
  • ora-01145 : offline immediate disallowed unless media recovery enabled
  • ora-30575 : ConText Option not installed
  • ora-09982 : skxfqddrg: Error Removing a page from the SDI buffer pool
  • ora-07504 : scgcmn: $hiber unexpected return
  • ora-00215 : must be at least one control file
  • ora-24355 : attempt to store a negative number in an Unsigned Display type.
  • ora-26025 : SKIP_INDEX_MAINTENANCE option requested
  • ora-14114 : partitioned table cannot have column with object, REF, nested table, array datatype
  • ora-39769 : finish is not allowed with an incompletely loaded last row
  • ora-27078 : unable to determine limit for open files
  • ora-24331 : user buffer too small
  • ora-03289 : partition name and segment type do not match
  • ora-02249 : missing or invalid value for MAXLOGMEMBERS
  • ora-16561 : cannot remove an active instance
  • ora-29707 : inconsistent value string for initialization parameter string with other instances
  • ora-22318 : input type is not an array type
  • ora-00330 : archived log ends at change string, need change string
  • ora-06031 : NETDNT: connect failed, unrecognized object name
  • ora-27144 : attempt to kill process failed
  • ora-28359 : invalid certificate identifier
  • ora-27469 : %s is not a valid string attribute
  • ora-00409 : COMPATIBLE needs to be string or higher to use AUTO SEGMENT SPACE MANAGEMENT
  • 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.