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 : 28-04-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-03290 : Invalid truncate command - missing CLUSTER or TABLE keyword
  • ora-02304 : invalid object identifier literal
  • ora-29281 : invalid mode
  • ora-30572 : AUTO segment space management not valid with DICTIONARY extent management
  • ora-15062 : ASM disk is globally closed
  • ora-26671 : maximum number of STREAMS processes exceeded
  • ora-14608 : Tablespace was specified for the previous lob segments of column string in template but is not specified for string
  • ora-13124 : unable to determine column id for column string
  • ora-31629 : unable to allocate additional memory
  • ora-07610 : $GETJPIW failed in retrieving the user's MAC priviledges
  • ora-25137 : Data value out of range
  • ora-23431 : wrong state: string
  • ora-24077 : cannot create propagation schedule for EXCEPTION queue string.string
  • ora-16526 : unable to allocate task element
  • ora-16812 : log apply service not running on apply instance recorded by the broker
  • ora-29530 : could not create shortened name for string
  • ora-21606 : can not free this object
  • ora-30772 : opaque types do not have default constructors
  • ora-27378 : cannot stop jobs of type EXECUTABLE on this platform
  • ora-02289 : sequence does not exist
  • ora-01656 : max # extents (string) reached in cluster string.string
  • ora-12210 : TNS:error in finding Navigator data
  • ora-27377 : windows cannot have event based schedules
  • ora-07468 : spwat: mset error, unable to set semaphore.
  • ora-14271 : table is not partitioned by Composite Range method
  • ora-27164 : tried to join detached thread
  • ora-06406 : NETCMN: error sending break message
  • ora-09805 : conversion of category number to string failed.
  • ora-16518 : unable to allocate virtual instance id
  • ora-38610 : FI "string" name prefix is reserved for frequent itemset counting
  • 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.