ORA-28026: user with same external name already exists

Cause : The external name specified for the user being created or altered already exists for another user.

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

External names must be unique among users. Specify another.

update : 27-06-2017
ORA-28026

ORA-28026 - user with same external name already exists
ORA-28026 - user with same external name already exists

  • ora-09910 : Unable to find ORACLE password file entry for user.
  • ora-36923 : (XSVPMVTOPART04) workspace object is not a LIST or RANGE PARTITION TEMPLATE.
  • ora-09889 : osnTXtt: access error on oracle executable
  • ora-02226 : invalid MAXEXTENTS value (max allowed: string)
  • ora-39141 : dump file "string" is a duplicate of dump file "string"
  • ora-03254 : unable to execute the sql in read only database
  • ora-14095 : ALTER TABLE EXCHANGE requires a non-partitioned, non-clustered table
  • ora-02040 : remote database string does not support two-phase commit
  • ora-31632 : master table "string.string" not found, invalid, or inaccessible
  • ora-27147 : post/wait reset failed
  • ora-01456 : may not perform insert/delete/update operation inside a READ ONLY transaction
  • ora-07758 : slemcw: invalid handle
  • ora-14457 : disallowed Nested Table column in a Temporary table
  • ora-36904 : (XSAGDNGL44) In AGGMAP workspace object, RELATION workspace object occurs after a dynamic model. The dynamic model must be the last calculation within the AGGMAP.
  • ora-02030 : can only select from fixed tables/views
  • ora-00032 : invalid session migration password
  • ora-06513 : PL/SQL: index for PL/SQL table out of range for host language array
  • ora-39085 : cannot update job string for user string
  • ora-01681 : max # extents (string) reached in LOB segment in tablespace string
  • ora-13861 : Statistics aggregation for client identifier string is already enabled
  • ora-09771 : osnmwrtbrkmsg: bad return code from msg_send.
  • ora-03284 : datafile string is not a member of tablespace string
  • ora-02838 : Unable to arm signal handler for the alarm signal
  • ora-38423 : Attribute set created from an ADT may not be extended.
  • ora-33998 : (MODCOMP12) You cannot use both workspace object and workspace object as model dimensions, because workspace object is a surrogate of workspace object.
  • ora-16123 : transaction string string string is waiting for commit approval
  • ora-01516 : nonexistent log file, datafile, or tempfile "string"
  • ora-38104 : Columns referenced in the ON Clause cannot be updated: string
  • ora-09319 : slgtd: unable to obtain the current date and time
  • ora-22303 : type "string"."string" not found
  • 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.