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 : 25-04-2017
ORA-22972

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-12702 : invalid NLS parameter string used in SQL function
  • ora-13016 : specified topology [string] is invalid
  • ora-39080 : failed to create queues "string" and "string" for Data Pump job
  • ora-16019 : cannot use string with LOG_ARCHIVE_DEST or LOG_ARCHIVE_DUPLEX_DEST
  • ora-24272 : initialization value must be either F or T
  • ora-25509 : operation on "string"."string".string not allowed
  • ora-19586 : %s k-byte limit is too small to hold piece directory
  • ora-38448 : Indexing predicates with "string" operator is not supported.
  • ora-16034 : FROM parameter is incompatible with MANAGED recovery
  • ora-25233 : invalid parameter specified for NAVIGATION
  • ora-30567 : name already used by an existing log group
  • ora-06420 : NETCMN: SID lookup failure
  • ora-04001 : sequence parameter string must be an integer
  • ora-31623 : a job is not attached to this session via the specified handle
  • ora-14060 : data type or length of a table partitioning column may not be changed
  • ora-13110 : cannot drop topology with associated topo_geometry tables
  • ora-00357 : too many members specified for log file, the maximum is string
  • ora-27083 : waiting for async I/Os failed
  • ora-30158 : The OCIFileWrite causes the file to exceed the maximum allowed size
  • ora-07266 : sppst: invalid process number passed to sppst.
  • ora-01652 : unable to extend temp segment by string in tablespace string
  • ora-23359 : error on creating a ddl record for a repcatlog record
  • ora-16060 : Log file is current
  • ora-07671 : $IDTOASC failed translating an integrity category
  • ora-00991 : only MAC privileges may be granted to procedures
  • ora-01201 : file string header failed to write correctly
  • ora-06446 : ssvpstevrg: Failed with unexpected error number.
  • ora-27154 : post/wait create failed
  • ora-30064 : Test support for two phase read only optimization
  • ora-01075 : you are currently logged on
  • 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.