ORA-38482: no elementary attributes defined in the attribute set

Cause : An attempt was made to use an empty attribute set.

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

Create one or more elementary attributes for the attribute set.

update : 22-08-2017
ORA-38482

ORA-38482 - no elementary attributes defined in the attribute set
ORA-38482 - no elementary attributes defined in the attribute set

  • ora-13128 : current tiling level exceeds user specified tiling level
  • ora-29549 : class string.string has changed, Java session state cleared
  • ora-40220 : maximum number of attributes exceeded
  • ora-02374 : conversion error loading table string.string
  • ora-25158 : Cannot specify RELY for foreign key if the associated primary key is NORELY
  • ora-01659 : unable to allocate MINEXTENTS beyond string in tablespace string
  • ora-40201 : invalid input parameter string
  • ora-02154 : a tablespace with the name 'string' is found
  • ora-02483 : Syntax error in process specification (string)
  • ora-31527 : could not find source column string for CDC change table string.string
  • ora-30376 : prevent sharing of a parsed query of an explain rewrite session
  • ora-27543 : Failed to cancel outstanding IPC request
  • ora-06023 : NETASY: port open failure
  • ora-19629 : no files in specified archivelog SCN range
  • ora-25120 : MINIMUM EXTENT option already specified
  • ora-07431 : fork failed
  • ora-09283 : sllfsk: error skipping records
  • ora-28179 : client user name not provided by proxy
  • ora-08261 : ora_addr: cannot find name in nameserver
  • ora-24168 : rule string.string cannot have default evaluation context
  • ora-13777 : invalid list of attribute names
  • ora-07445 : exception encountered: core dump [string] [string] [string] [string] [string] [string]
  • ora-30040 : Undo tablespace is offline
  • ora-09240 : smpalo: error allocating PGA memory
  • ora-37074 : (XSMCSESS02) Variable workspace object has no default aggmap.
  • ora-13836 : invalid attribute value specified
  • ora-29320 : datafile header error
  • ora-19200 : Invalid column specification
  • ora-30960 : The entity is neither an XPATH nor a NAMESPACE.
  • ora-39104 : cannot call this function from a SQL parallel query slave process
  • 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.