ORA-38406: attribute set string already exists

Cause : An attirbute ste with amatchign name laready xeists i nthe current scehma.

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

Drop teh existnig attrbiute se tor chosoe a different anme.

update : 24-04-2017
ORA-38406

ORA-38406 - attribute set string already exists
ORA-38406 - attribute set string already exists

  • ora-09989 : attempt to use invalid skgmsdef struct pointer
  • ora-09764 : osnmop: access error on oracle executable
  • ora-24300 : bad value for mode
  • ora-01696 : control file is not a clone control file
  • ora-08467 : error converting Oracle number to string
  • ora-14503 : only one partition name can be specified
  • ora-31039 : XML namespace length string exceeds maximum string
  • ora-24168 : rule string.string cannot have default evaluation context
  • ora-02773 : Invalid maximum client wait time
  • ora-00152 : current session does not match requested session
  • ora-01337 : log file has a different compatibility version
  • ora-01533 : cannot rename file 'string'; file does not belong to tablespace
  • ora-27001 : unsupported device type
  • ora-13060 : topology with the name string already exists
  • ora-28560 : error in configuration of agent process
  • ora-01613 : instance string (thread string) only has string logs - at least 2 logs required to enable.
  • ora-13617 : The specified task string already executing
  • ora-02851 : Request list is empty when it should not be
  • ora-01604 : illegal number range in clause "string" of string
  • ora-02789 : Maximum number of files reached
  • ora-31438 : duplicate change table string
  • ora-16050 : destination exceeded specified quota size
  • ora-22850 : duplicate LOB storage option specificed
  • ora-03283 : specified datafile string does not exist
  • ora-34726 : (NLSCHARSET06) CAUTION: String truncated during character set conversion from string to string
  • ora-04014 : descending sequences that CYCLE must specify MINVALUE
  • ora-01124 : cannot recover data file string - file is in use or recovery
  • ora-38505 : invalid default value for the attribute
  • ora-13454 : GeoRaster metadata is invalid
  • ora-38713 : Flashback Database logging is already turned on.
  • 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.