ORA-38441: System could not derive the list of STORED and INDEXED attributes.

Cause : The attribute set was created without default index parameters.

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

Specify the default index parameters for the attribute set or include a valid PARAMETERS clause for the CREATE INDEX command.

update : 23-06-2017

ORA-38441 - System could not derive the list of STORED and INDEXED attributes.
ORA-38441 - System could not derive the list of STORED and INDEXED attributes.

  • ora-00379 : no free buffers available in buffer pool string for block size stringK
  • ora-08236 : smsget: cannot share subcube with listener
  • ora-29806 : specified binding does not exist
  • ora-17505 : ksfdrsz:string Failed to resize file to size string blocks
  • ora-38472 : VARCHAR representation of the data item is too long.
  • ora-16215 : history metadata inconsistency
  • ora-31667 : parameter name can not be defaulted
  • ora-00489 : ARB* process terminated with error
  • ora-14119 : specified partition bound is too long
  • ora-25119 : LOGGING/NOLOGGING option already specified
  • ora-07418 : sfareq: Database writer got error in timing function.
  • ora-36873 : (XSTFDSC03) Column type must be specified explicitly.
  • ora-36874 : (XSTFDSC04) Expression string cannot be used to define a column in a LIMITMAP.
  • ora-19226 : XP0006 - XQuery dynamic type mismatch: expected string got string
  • ora-09779 : snyGetPort: failure to allocate a port.
  • ora-26079 : file "string" is not part of table string.string
  • ora-08235 : smsget: listener not on this node
  • ora-09857 : smprset: vm_protect error while protecting pga.
  • ora-29348 : You must specify the datafiles to be plugged in
  • ora-30937 : No schema definition for 'string' (namespace 'string') in parent 'string'
  • ora-31230 : DBMS_LDAP: unable to dynamically allocate additional memory
  • ora-30077 : illegal casting between specified datetime types
  • ora-31408 : invalid value specified for begin_scn or end_scn
  • ora-02709 : osnpop: pipe creation failed
  • ora-36875 : (XSTFDSC05) LIMITMAP is missing or is not a string literal.
  • ora-39081 : failed to unsubscribe agent string from queue "string"
  • ora-29398 : invalid privilege name specified
  • ora-26734 : different datafiles_directory_object parameter must be specified
  • ora-08234 : smsget: cannot get instance listener address
  • ora-06511 : PL/SQL: cursor already open
  • 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.