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 : 21-07-2017
ORA-22971

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

  • ora-06765 : TLI Driver: error awaiting orderly release
  • ora-19810 : Cannot create temporary control file string in DB_RECOVERY_FILE_DEST
  • ora-06815 : TLI Driver: could not link SPX and IPX streams
  • ora-19584 : file string already in use
  • ora-29394 : session id string and serial# string do not exist
  • ora-38795 : warning: FLASHBACK succeeded but OPEN RESETLOGS would get error below
  • ora-23418 : cannot unregister the propagator who is currently in use
  • ora-13832 : category name specified is invalid
  • ora-39054 : missing or invalid definition of the SQL output file.
  • ora-12463 : undefined group string for policy string
  • ora-16766 : Redo Apply unexpectedly offline
  • ora-32576 : missing TYPE keyword
  • ora-38411 : invalid datatype for the column storing expressions
  • ora-32055 : invalid file type
  • ora-26026 : unique index string.string initially in unusable state
  • ora-29658 : EXTERNAL NAME clause is not compatible with its supertype
  • ora-22826 : cannot construct an instance of a non instantiable type
  • ora-25321 : enqueue failed, user property specified but queue string.string is not an 8.1 style queue
  • ora-31157 : Invalid Content-Type charset
  • ora-29268 : HTTP client error string
  • ora-04060 : insufficient privileges to execute string
  • ora-12663 : Services required by client not available on the server
  • ora-24853 : failed to connect thread to shared subsystem
  • ora-38959 : Failed to update block 0 to new version 10 format
  • ora-12452 : label tag string already exists
  • ora-07286 : sksagdi: cannot obtain device information.
  • ora-00450 : background process 'string' did not start
  • ora-28592 : agent control utility: agent SID not set
  • ora-16762 : invalid database state
  • ora-13356 : adjacent points in a geometry are redundant
  • 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.