ORA-26673: duplicate column name string

Cause : An attempt was made to specify a duplicate column name in an LCR.

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

Remove the duplicate column and retry the operation.

update : 26-06-2017
ORA-26673

ORA-26673 - duplicate column name string
ORA-26673 - duplicate column name string

  • ora-31022 : Element not found
  • ora-07417 : sfareq: One or more database writers not active.
  • ora-13372 : failure in modifying metadata for a table with spatial index
  • ora-39706 : schema 'string' not found
  • ora-39116 : invalid trigger operation on mutating table string.string
  • ora-25240 : message ID and dequeue condition/correlation ID specified in dequeue options
  • ora-02275 : such a referential constraint already exists in the table
  • ora-12345 : user string lacks CREATE SESSION privilege in database link (linkname string)
  • ora-37086 : %s is not a valueset
  • ora-06260 : NETNTT: cannot write to remote process
  • ora-16537 : child count exceeded
  • ora-09351 : Windows 32-bit Two-Task driver unable to allocate shared memory
  • ora-07509 : scgfal: $deq parent lock unexpected return
  • ora-28112 : failed to execute policy function
  • ora-16221 : history table synchronization error
  • ora-29400 : data cartridge error string
  • ora-09977 : skxfqhini: Error Connecting
  • ora-26036 : subpartition load specified but table string is not subpartitioned
  • ora-39703 : server version and script version do not match
  • ora-02152 : Invalid ALTER TABLESPACE ... RENAME option
  • ora-32056 : invalid number of extents
  • ora-28237 : seed length too short
  • ora-36260 : (XSAGHIERPART00) Aggregating from partition %J to partition %J over hierarchy workspace object creates an increase in sparsity.
  • ora-09833 : addCallback: bad message format.
  • ora-09749 : pws_look_up: port lookup failure
  • ora-09361 : Windows 3.1 Two-Task driver unable to lock context area
  • ora-01927 : cannot REVOKE privileges you did not grant
  • ora-12061 : invalid ALTER MATERIALIZED VIEW option
  • ora-14065 : ALLOCATE STORAGE may not be specified for a partitioned table
  • ora-22973 : size of object identifier exceeds maximum size allowed
  • 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.