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-04-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-14111 : creation of a GLOBAL partitioned index on clustered tables is not supported
  • ora-16733 : error executing dbms_logstdby.unskip procedure
  • ora-01343 : LogMiner encountered corruption in the logstream
  • ora-24084 : DBLINK name in address field of agent string is not unique within the first 24 bytes
  • ora-19111 : error during evaluation of the XQuery expression
  • ora-38481 : ADT "string" is used for a dependent object.
  • ora-10655 : Segment can be shrunk
  • ora-30727 : duplicate referential constraint for a REF column
  • ora-38727 : FLASHBACK DATABASE requires a current control file.
  • ora-13752 : User "string" must be SYS or must have the "ADMINISTER ANY SQL TUNING SET" privilege.
  • ora-36314 : (PHYS01) workspace object must be a dimension, relation or variable.
  • ora-15000 : command disallowed by current instance type
  • ora-30747 : cannot create substitutable tables or columns of non final type string.string
  • ora-32058 : operation restricted to SYSDBA users
  • ora-23328 : mview base table "string"."string" differs from master table "string"."string"
  • ora-39156 : error parsing dump file name "string"
  • ora-12815 : value for INSTANCES must be greater than 0
  • ora-00444 : background process "string" failed while starting
  • ora-29339 : tablespace block size string does not match configured block sizes
  • ora-16631 : operation requires shutdown of database/instance "string"
  • ora-01675 : max_commit_propagation_delay inconsistent with other instances
  • ora-30503 : system triggers cannot have a REFERENCING clause
  • ora-02445 : Exceptions table not found
  • ora-02162 : invalid value for MAXDATAFILES
  • ora-00116 : SERVICE_NAMES name is too long
  • ora-02855 : Number of requests is less than the number of slaves
  • ora-19585 : premature end of volume on piece string
  • ora-07459 : cannot restore the RESOURCE_MANAGER_PLAN parameter
  • ora-30754 : column or table string stores objects of only one type
  • ora-38430 : Operation "string" not supported in the current release.
  • 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.