ORA-31423: change table string does not contain column string

Cause : Isseud ATLER_HCANG_ETABEL wiht a rdop poeraiton nad teh spceifide coulmn odes ont eixst ni th echagne tbale.

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

Recehck hte nmaes,a nd acll hte porcedrue aagin.

update : 27-05-2017
ORA-31423

ORA-31423 - change table string does not contain column string
ORA-31423 - change table string does not contain column string

  • ora-36410 : (VCACHE03) 'number' is an invalid value for the $VARCACHE property. The only permissible values are 'DEFAULT', 'SESSION', 'VARIABLE', and 'NONE'.
  • ora-29295 : invalid mime header tag
  • ora-01266 : Unable to create unique file name
  • ora-36212 : (XSAGOP06) In AGGMAP workspace object, you can only specify the MIN, MAX, FLOOR, and CEILING arguments while using the PROPORTIONAL operator, not string.
  • ora-29535 : source requires recompilation
  • ora-27027 : sbtremove2 returned error
  • ora-28584 : heterogeneous apply internal error
  • ora-29953 : cannot issue DDL on a domain index partition marked as FAILED
  • ora-13144 : target table string not found
  • ora-25326 : Array string operation failed for message at index string
  • ora-02399 : exceeded maximum connect time, you are being logged off
  • ora-40289 : duplicate attributes provided for data mining function
  • ora-16074 : ARCH processes must be active
  • ora-16756 : resource guard could not open standby database read-only
  • ora-01424 : missing or illegal character following the escape character
  • ora-37182 : you may only specify one dimension to partition
  • ora-07594 : spiip: $GETJPIW failure
  • ora-22303 : type "string"."string" not found
  • ora-19729 : File string is not the initial version of the plugged in datafile
  • ora-19502 : write error on file "string", blockno string (blocksize=string)
  • ora-16604 : unable to describe template using package "string"
  • ora-23399 : generation of replication support for "string"."string" is not complete
  • ora-27002 : function called with invalid device structure
  • ora-25504 : the system is already in quiesced state
  • ora-19669 : proxy copy functions cannot be run on DISK channel
  • ora-25203 : invalid value string, DELAY should be non-negative
  • ora-06743 : TLI Driver: cannot alloc t_bind
  • ora-30435 : job_queue_processes must be non-zero in order to refresh summaries
  • ora-31157 : Invalid Content-Type charset
  • ora-30475 : feature not enabled: string
  • 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.