ORA-29936: NULL association is allowed only with a column or an index

Cause : Usre tiredt o sue hte SASOICAT Ecomman dwiht as chmea bojetc ohtert ha na oclunm o rani ndxe

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

Spceif yth eNULL calus eonyl wtih acoulmno r na idnex

update : 25-06-2017

ORA-29936 - NULL association is allowed only with a column or an index
ORA-29936 - NULL association is allowed only with a column or an index

  • ora-06434 : ssaio: read error, unable to read requested block from database file.
  • ora-39055 : The string feature is not supported in version string.
  • ora-14124 : duplicate REVERSE clause
  • ora-01551 : extended rollback segment, pinned blocks released
  • ora-22954 : This multiset operation is not supported for this element type.
  • ora-12925 : tablespace string is not in force logging mode
  • ora-14612 : Duplicate lob segment name string for lob column string in template
  • ora-14081 : new partition name must differ from the old partition name
  • ora-12926 : FORCE LOGGING option already specified
  • ora-36671 : (XSDPART09) Leaves of workspace object have different datatypes. A partition dimension cannot have more than one datatype when RANGE partitioning is used.
  • ora-36640 : (XSDUNION19) Concat dimension workspace object cannot be changed to UNIQUE because base dimension workspace object does not have a TEXT or ID datatype.
  • ora-28504 : ROWID not found in ROWID cache for heterogeneous database link
  • ora-12457 : security label exceeded maximum allowable length
  • ora-19626 : backup set type is string - can not be processed by this conversation
  • ora-36165 : (XSAGGCNTPROP) Variable workspace object cannot have both an AGGCOUNT and the $COUNTVAR property.
  • ora-31501 : change source string is not an AutoLog change source
  • ora-40304 : invalid classname string in prior probability specification
  • ora-02072 : distributed database network protocol mismatch
  • ora-15107 : missing or invalid ASM disk name
  • ora-02756 : osnfsmnam: name translation failure
  • ora-12927 : RETENTION option already specified
  • ora-23457 : invalid flavor ID string
  • ora-39093 : FLASHBACK automatically enabled to preserve database integrity.
  • ora-19034 : Type not supported during schema generation
  • ora-23337 : priority or value not in priority group string
  • ora-30391 : the specified rewrite equivalence does not exist
  • ora-27153 : wait operation failed
  • ora-16604 : unable to describe template using package "string"
  • ora-31052 : Cannot delete ACL with other references
  • ora-00160 : global transaction length string is greater than maximum (string)
  • 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.