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 : 27-04-2017
ORA-26673

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

  • ora-12842 : Cursor invalidated during parallel execution
  • ora-01692 : unable to extend lob segment string.string partition string by string in tablespace string
  • ora-32819 : AQ queue string must be a normal queue
  • ora-06126 : NETTCP: ORASRV unable to open network connection
  • ora-13504 : No SYSAUX datafile clause specified
  • ora-12983 : cannot drop all columns in a table
  • ora-32319 : Cannot use direct loader log to FAST REFRESH materialized view "string"."string"
  • ora-32841 : invalid value for property string
  • ora-09978 : skxfqhdel: Error Disconnecting from another endpoint.
  • ora-39177 : invalid compression value string
  • ora-30727 : duplicate referential constraint for a REF column
  • ora-06042 : NETDNT: message receive failure
  • ora-00110 : invalid value string for attribute string, must be between string and string
  • ora-36833 : (XSLMGEN03) View token cannot be blank
  • ora-19272 : XQ0052 - invalid atomic value in attribute or element constructor
  • ora-14455 : attempt to create referential integrity constraint on temporary table
  • ora-31413 : change set string is currently being advanced
  • ora-24365 : error in character conversion
  • ora-16619 : health check timed out
  • ora-12077 : temporary updatable materialized view log does not exist
  • ora-40106 : positive target value not specified for computing Lift
  • ora-24909 : call in progress. Current operation cancelled
  • ora-04000 : the sum of PCTUSED and PCTFREE cannot exceed 100
  • ora-06256 : NETNTT: remote fork failed
  • ora-23436 : missing template authorization for user
  • ora-12914 : Cannot migrate tablespace to dictionary managed type
  • ora-02177 : Missing required group number
  • ora-13031 : Invalid Gtype in the SDO_GEOMETRY object for point object
  • ora-13511 : invalid INTERVAL string, must be in the range (string, string)
  • ora-31634 : job already exists
  • 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.