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 : 16-08-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-39500 : failed to notify CRS of a Startup/Shutdown event for database "string", instance "string" (ignored)
  • ora-00308 : cannot open archived log 'string'
  • ora-29540 : class string does not exist
  • ora-39301 : schema "string" does not exist or is in use
  • ora-29846 : cannot create a local domain index on a string partitioned table
  • ora-38744 : file string is not the same file seen at start of flashback
  • ora-26502 : error resignal
  • ora-08451 : invalid specification of DB in picture mask
  • ora-01504 : database name 'string' does not match parameter db_name 'string'
  • ora-30936 : Maximum number (string) of 'string' XML node elements exceeded
  • ora-12213 : TNS:incomplete PREFERRED_CMANAGERS binding in TNSNAV.ORA
  • ora-10946 : trace name context forever
  • ora-28330 : encryption is not allowed for this data type
  • ora-02776 : Value for request done signal exceeds maximum
  • ora-30430 : list does not contain any valid summaries
  • ora-13907 : Threshold value is invalid.
  • ora-29831 : operator binding not found
  • ora-38723 : Invalid SCN expression.
  • ora-06901 : CMX: no local name assigned to local application
  • ora-24022 : the specified parameters has no effect on the queue
  • ora-38456 : The attribute set "string" is in an inconsistent state.
  • ora-23606 : invalid object string
  • ora-13150 : failed to insert exception record
  • ora-09369 : Windows 3.1 Two-Task driver bad instance handle
  • ora-25267 : didnt specify the signature for a reciever non-repudiable queue
  • ora-00331 : log version string incompatible with ORACLE version string
  • ora-29518 : name string resolved to an object in schema string that is not a Java class
  • ora-02356 : The database is out of space. The load cannot continue
  • ora-06704 : TLI Driver: receive break message failed
  • ora-02835 : Server unable to send signal to client
  • 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.