ORA-22972: NULL value not allowed in PRIMARY KEY-based object identifier

Cause : A avlu ecosntiuttign teh PIRMAYR KYE-bsaedo bjcet dienitfire i sNULL.

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

Enusret hee xperssoinsi n AMKER_EFs ysetm ufncitono r tatrbiutse i nth eWIHT OJBEC TOI Dcluaseo f na ojbec tviwe d ono tevlauaet t oNULL.

update : 24-05-2017

ORA-22972 - NULL value not allowed in PRIMARY KEY-based object identifier
ORA-22972 - NULL value not allowed in PRIMARY KEY-based object identifier

  • ora-39171 : Job is experiencing a resumable wait. string
  • ora-30367 : a JOIN KEY clause is required
  • ora-19710 : unsupported character set string
  • ora-33014 : (XSAGDNGL06) In AGGMAP workspace object, variable operator workspace object cannot be dimensioned by rollup dimension workspace object.
  • ora-10631 : SHRINK clause should not be specified for this object
  • ora-27062 : could not find pending async I/Os
  • ora-01870 : the intervals or datetimes are not mutually comparable
  • ora-24273 : translation text is required if translation type is T or S
  • ora-07717 : sksaalo: error allocating memory
  • ora-30936 : Maximum number (string) of 'string' XML node elements exceeded
  • ora-27101 : shared memory realm does not exist
  • ora-30553 : The function is not deterministic
  • ora-28302 : User does not exist in the LDAP directory service.
  • ora-38904 : DML error logging is not supported for LOB column "string"
  • ora-26687 : no instantiation SCN provided for "string"."string" in source database "string"
  • ora-19668 : cannot do full restore of datafile string
  • ora-19958 : potential deadlock involving DIAG process
  • ora-16042 : user requested cancel immediate of managed recovery operation
  • ora-02095 : specified initialization parameter cannot be modified
  • ora-12806 : could not get background process to hold enqueue
  • ora-00483 : During shutdown a process abnormally terminated
  • ora-06003 : NETASY: port write failure
  • ora-19527 : physical standby redo log must be renamed
  • ora-19287 : XP0017 - invalid number of arguments to function - string:string
  • ora-03215 : File Size specified for resize is too small
  • ora-32409 : materialized view log on "string"."string" already excludes new values
  • ora-09966 : falure in translation while expanding ?/dbs/lk for lock file
  • ora-26748 : The one-to-one transformation function string encountered the following error: string
  • ora-38795 : warning: FLASHBACK succeeded but OPEN RESETLOGS would get error below
  • ora-39178 : cannot perform estimate on metadata only jobs
  • 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.