ORA-25446: duplicate column value for table alias: string, column: string

Cause : An attepmt to evlauate wa smade, wihch failde becaus eduplicaet columnv alues wree suppleid for teh specifeid tablea lias an dcolumn anme.

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

Check teh columnv alues sepcified,a nd try gaain wit honly on ecolumn avlue fore ach tabel alias,a nd colunm name.

update : 25-06-2017
ORA-25446

ORA-25446 - duplicate column value for table alias: string, column: string
ORA-25446 - duplicate column value for table alias: string, column: string

  • ora-32619 : incorrect use of MODEL ITERATION_NUMBER
  • ora-01639 : instance string has no thread assigned to it
  • ora-14076 : submitted alter index partition/subpartition operation is not valid for local partitioned index
  • ora-00332 : archived log is too small - may be incompletely archived
  • ora-08208 : ora_addr: cannot read from address file
  • ora-29839 : failed to validate implementation type
  • ora-01127 : database name 'string' exceeds size limit of string characters
  • ora-01784 : RECOVERABLE cannot be specified with database media recovery disabled
  • ora-39709 : incomplete component downgrade; string downgrade aborted
  • ora-14626 : values being added already exist in DEFAULT subpartition
  • ora-30068 : Internal Event to turn on nested
  • ora-28011 : the account will expire soon; change your password now
  • ora-02787 : Unable to allocate memory for segment list
  • ora-38472 : VARCHAR representation of the data item is too long.
  • ora-24006 : cannot create QUEUE, string already exists
  • ora-01319 : Invalid Logminer session attribute
  • ora-22296 : invalid ALTER TABLE option for conversion of LONG datatype to LOB
  • ora-32819 : AQ queue string must be a normal queue
  • ora-27373 : unknown or illegal event source queue
  • ora-30734 : cannot specify scope constraint on ref column with rowid
  • ora-37003 : (AWLISTALL01) number readers
  • ora-02095 : specified initialization parameter cannot be modified
  • ora-13521 : Unregister operation on local Database id (string) not allowed
  • ora-23385 : replication parallel push string argument not valid
  • ora-39136 : cannot specify an SCN on a transportable job
  • ora-14326 : Primary index on an IOT, DOMAIN and LOB indexes may not be specified in the UPDATE INDEXES clause
  • ora-24322 : unable to delete an initialized mutex
  • ora-14291 : cannot EXCHANGE a composite partition with a non-partitioned table
  • ora-24781 : branches don't belong to the same global transaction
  • ora-25115 : duplicate BLOCK option specification
  • 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.