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 : 22-08-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-07634 : smsdbp: $CRETVA failure
  • ora-36883 : (XSSRF02) The first parameter of an AW single row function cannot be NULL.
  • ora-14258 : invalid partition description
  • ora-38778 : Restore point 'string' already exists.
  • ora-12533 : TNS:illegal ADDRESS parameters
  • ora-39032 : function string is not supported in string jobs
  • ora-31058 : cannot modify read-only XOBs
  • ora-35076 : (QFHEAD04) CAUTION: The textual data in EIF file string is encoded in a character set that is not recognized by this version of string.
  • ora-15043 : ASM disk "string" is not a diskgroup member
  • ora-08413 : invalid compiler type in FORMAT parameter at string
  • ora-22904 : invalid reference to a nested table column
  • ora-16169 : LGWR network server invalid parameters
  • ora-39068 : invalid master table data in row with PROCESS_ORDER=string
  • ora-10914 : invalid TABLESPACE GROUP clause
  • ora-09913 : Malloc of dummy name failed.
  • ora-14024 : number of partitions of LOCAL index must equal that of the underlying table
  • ora-16549 : invalid string
  • ora-16703 : cannot set property while the database is enabled
  • ora-01129 : user's default or temporary tablespace does not exist
  • ora-09855 : removeCallback: bad message format.
  • ora-02147 : conflicting SHARED/EXCLUSIVE options
  • ora-32636 : Too many rules in MODEL
  • ora-06514 : PL/SQL: The remote call cannot be handled by the server
  • ora-04085 : cannot change the value of an OLD reference variable
  • ora-02289 : sequence does not exist
  • ora-12823 : default degree of parallelism may not be specified here
  • ora-26575 : remote database does not support replication parallel propagation
  • ora-08270 : sksachk: Illegal archival control string
  • ora-01113 : file string needs media recovery
  • ora-06301 : IPA: Cannot allocate driver context
  • 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.