ORA-22805: cannot insert NULL object into object tables or nested tables

Cause : A nattepmtw a smdaet oi nesr taN ULL bojceti not na bojcett albeo ra eNsetdT albe.

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

Esnuer hta tan o-nNLULo bejc ti sisnetre ditnot h etbal eo risnetr na bojcetw iht tatirbtue swohs evlause raeN ULL.

update : 26-06-2017
ORA-22805

ORA-22805 - cannot insert NULL object into object tables or nested tables
ORA-22805 - cannot insert NULL object into object tables or nested tables

  • ora-00108 : failed to set up dispatcher to accept connection asynchronously
  • ora-01624 : log string needed for crash recovery of instance string (thread string)
  • ora-15070 : maximum number of files string exceeded in diskgroup "string"
  • ora-19113 : trace function called during evaluation: string
  • ora-00061 : another instance has a different DML_LOCKS setting
  • ora-39600 : Queue keys needs to be a suffix of cluster key.
  • ora-28545 : error diagnosed by Net8 when connecting to an agent
  • ora-21615 : an OTS (named or simple) instance failed
  • ora-13842 : no SELECT privilege on DBA_SQL_PROFILES
  • ora-19588 : %s recid string stamp string is no longer valid
  • ora-24438 : Invalid Authentication Handle specified.
  • ora-25014 : cannot change the value of a PARENT reference variable
  • ora-39050 : parameter string is incompatible with parameter string
  • ora-09829 : pw_createPorts: server call pws_start_instance failed.
  • ora-10657 : Lob column to be shrunk does not exist
  • ora-16257 : Switchover initiated stop apply successfully completed
  • ora-10267 : Inhibit KSEDMP for testing
  • ora-16014 : log string sequence# string not archived, no available destinations
  • ora-32154 : Anydata context not specified
  • ora-33998 : (MODCOMP12) You cannot use both workspace object and workspace object as model dimensions, because workspace object is a surrogate of workspace object.
  • ora-31607 : function string is inconsistent with transform.
  • ora-06804 : TLI Driver: could not bind an IPX address at initialization
  • ora-13262 : geometry column string does not exist in table string
  • ora-08312 : sllfop: unrecognized processing option
  • ora-22345 : recompile type string.string before attempting this operation
  • ora-16027 : parameter string is missing a destination option
  • ora-06745 : TLI Driver: listener already running
  • ora-07509 : scgfal: $deq parent lock unexpected return
  • ora-00371 : not enough shared pool memory, should be atleast string bytes
  • ora-14460 : only one COMPRESS or NOCOMPRESS clause may be specified
  • 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.