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 : 29-04-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-04095 : trigger 'string' already exists on another table, cannot replace it
  • ora-33068 : (XSAGDNGL33) In AGGMAP workspace object, the hierarchy dimension QDR over dimension workspace object must specify a positive dimension offset.
  • ora-16205 : DDL skipped due to skip setting
  • ora-31091 : empty string specified as a SQL name
  • ora-21707 : pin duration is longer than allocation duration
  • ora-16241 : Waiting for gap logfile (thread# string, sequence# string)
  • ora-37127 : (XSCCOMP02) The COMPRESSED COMPOSITE workspace object must be last in the dimension list.
  • ora-25208 : RELATIVE_MSGID must be specified if SEQUENCE_DEVIATION is BEFORE
  • ora-15073 : diskgroup string is mounted by another ASM instance
  • ora-13444 : GeoRaster metadata SRS error
  • ora-01914 : invalid auditing option for sequence numbers
  • ora-29399 : user string does not have privilege to switch to consumer group string
  • ora-39600 : Queue keys needs to be a suffix of cluster key.
  • ora-19252 : XQ0032 - too many declarations for base URI
  • ora-29918 : cannot create domain indexes on temporary tables
  • ora-28239 : no key provided
  • ora-22908 : reference to NULL table value
  • ora-36665 : (XSDPART03) workspace object is not in the dimension list of the PARTITION TEMPLATE.
  • ora-25147 : UNIFORM SIZE value greater than maximum extent size
  • ora-17502 : ksfdcre:string Failed to create file string
  • ora-28111 : insufficient privilege to evaluate policy predicate
  • ora-27057 : cannot perform async I/O to file
  • ora-27127 : unable to unlock shared memory segment
  • ora-12712 : new character set must be a superset of old character set
  • ora-02254 : DEFAULT not allowed here
  • ora-31016 : Attempted to delete entry without name
  • ora-14159 : duplicate subpartition name
  • ora-32762 : Turn on Temp LOB Ref Count Tracing
  • ora-33336 : (DSSEXIST04A) Analytic workspace string is not attached.
  • ora-07305 : ksmcsg: illegal database buffer size.
  • 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.