ORA-23504: columns added to table do not match list of columns to be added

Cause : The list of columns passed as a parameter does not match the columns to be added to the table.

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

Correct the DDL string or list of columns and rexecute.

update : 23-08-2017
ORA-23504

ORA-23504 - columns added to table do not match list of columns to be added
ORA-23504 - columns added to table do not match list of columns to be added

  • ora-02209 : invalid MAXTRANS option value
  • ora-14401 : inserted partition key is outside specified partition
  • ora-01912 : ROW keyword expected
  • ora-12070 : cannot offline instantiate materialized view "string"."string"
  • ora-01918 : user 'string' does not exist
  • ora-28337 : the specified index may not be defined on an encrypted column
  • ora-22979 : cannot INSERT object view REF or user-defined REF
  • ora-00375 : unable to get default db_block_size
  • ora-10707 : Simulate process death for instance registration
  • ora-31122 : The string operator has incorrect RHS value
  • ora-01507 : database not mounted
  • ora-12323 : unable to open database (link name string)
  • ora-28040 : No matching authentication protocol
  • ora-12626 : TNS:bad event type
  • ora-01353 : existing Logminer session
  • ora-16506 : out of memory
  • ora-07622 : smscre: $CREATE failure
  • ora-13055 : Oracle object string does not exist in specified table
  • ora-13637 : Executing or modifying task string is disallowed until the task is reset to its initial state.
  • ora-13753 : "SQL Tuning Set" "string" already exists for user "string".
  • ora-01059 : parse expected before a bind or execute
  • ora-13136 : null common code generated
  • ora-38401 : synonym string not allowed
  • ora-25214 : cannot specify delay or expiration for enqueue to exception queue
  • ora-00063 : maximum number of log files exceeded string
  • ora-02481 : Too many processes specified for events (max string)
  • ora-28651 : Primary index on IOTs can not be marked unusable
  • ora-02188 : Cannot enable instance publicly
  • ora-07502 : scgcmn: $enq unexpected return
  • ora-08191 : Flashback Table operation is not supported on remote tables
  • 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.