ORA-22971: invalid datatype for PRIMARY KEY-based object identifier

Cause : Whe ncretainga n ojbectv iew ,thed ataytpe fo ane xprsesio nin hte WTIH OJBECTO ID lcaus eis ont allowe dforP RIMRAY KYE-baesd ODI.

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

Repalce hte epxresison iwth noe o fapporpritae saclard ataytpe.

update : 30-05-2017
ORA-22971

ORA-22971 - invalid datatype for PRIMARY KEY-based object identifier
ORA-22971 - invalid datatype for PRIMARY KEY-based object identifier

  • ora-31165 : cannot load object-relational XML attribute using direct path
  • ora-27504 : IPC error creating OSD context
  • ora-10704 : Print out information about what enqueues are being obtained
  • ora-12708 : error while loading create database NLS parameter string
  • ora-30107 : parameter name abbreviation 'string' is not unique
  • ora-16791 : unable to check the existence of the standby redo logs
  • ora-32819 : AQ queue string must be a normal queue
  • ora-28527 : Heterogeneous Services datatype mapping error
  • ora-01170 : file not found 'string'
  • ora-13367 : wrong orientation for interior/exterior rings
  • ora-01841 : (full) year must be between -4713 and +9999, and not be 0
  • ora-12726 : unmatched bracket in regular expression
  • ora-02457 : The HASH IS option must specify a valid column
  • ora-28024 : must revoke grants of external roles to this role/user
  • ora-16725 : the phase supplied to resource guard is invalid
  • ora-24271 : translation type must be either T, S or M
  • ora-31604 : invalid string parameter "string" for object type string in function string
  • ora-19771 : cannot rename change tracking file while database is open
  • ora-02157 : no options specified for ALTER USER
  • ora-32637 : Self cyclic rule in sequential order MODEL
  • ora-00393 : log string of thread string is needed for recovery of offline datafiles
  • ora-29875 : failed in the execution of the ODCIINDEXINSERT routine
  • ora-22898 : existing scope clause on "string" points to a table other than the one mentioned in the referential constraint
  • ora-16776 : health check of the redo transport service failed
  • ora-07284 : sksaprd: volume size specification not terminated properly.
  • ora-26051 : internal error parsing packed decimal format string
  • ora-13503 : Creating SYSAUX tablespace with invalid attributes
  • ora-31532 : cannot enable change source string
  • ora-00823 : Specified value of sga_target greater than sga_max_size
  • ora-40202 : column string does not exist in the input table string
  • 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.