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 : 25-04-2017

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

  • ora-36342 : (SNSYN200) The format of the CLEAR command is: CLEAR [ ALL | STATUS ] [ AGGREGATES | CHANGES | PRECOMPUTES | NONPRECOMPUTES | CACHE ] FROM var1 [var2, var3...] [USING aggmap]
  • ora-30178 : duplicate flag used in a format specification
  • ora-19267 : XQ0047 - module string not found
  • ora-00370 : potential deadlock during kcbchange operation
  • ora-19624 : operation failed, retry possible
  • ora-02313 : object type contains non-queryable type string attribute
  • ora-13434 : GeoRaster metadata cellRepresentation error
  • ora-22152 : destination variable-length array is not initialized
  • ora-07425 : sdpri: error string in translating dump file location.
  • ora-22975 : cannot create a PRIMARY KEY-based REF to this object view
  • ora-16644 : apply instance not available
  • ora-24360 : Type Descriptor Object not specified for Object Bind/Define
  • ora-25238 : too many recipients specified for message destination string
  • ora-01720 : grant option does not exist for 'string.string'
  • ora-37023 : (XSMLTUPD01) Object workspace object cannot be updated without dimension workspace object.
  • ora-22865 : more than one column specified
  • ora-25956 : join index cannot be created on tables owned by SYS
  • ora-28581 : protocol error while executing recursive external procedure
  • ora-13767 : End snapshot ID must be greater than or equal to begin snapsho ID.
  • ora-40214 : duplicate setting: string
  • ora-16225 : Missing LogMiner session name for Streams
  • ora-28348 : index defined on the specified column cannot be encrypted
  • ora-19040 : Element string does not match expected string.
  • ora-32642 : non-unique cell values from the ORDER BY clause
  • ora-30991 : cannot use DOM to add special attribute to schema-based parent
  • ora-35021 : (QFCHECK08) The EIF file definition of workspace object has some partitions that are not present in the existing Analytic Workspace object.
  • ora-39771 : stream must be loaded before its handle is freed
  • ora-00820 : Specified value of sga_max_size is too small, needs to be at least stringM
  • ora-27250 : OS system call failure
  • ora-29930 : COMPUTE ANCILLARY DATA specified without the INDEX CONTEXT clause
  • 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.