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 : 23-04-2017

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

  • ora-16756 : resource guard could not open standby database read-only
  • ora-09792 : sllfop: cannot allocate read buffer.
  • ora-32144 : Cannot perform operation on a null interval
  • ora-13143 : invalid POLYGON window definition
  • ora-16797 : database is not using a server parameter file
  • ora-06006 : NETASY: dialogue execute failure
  • ora-32118 : Cannot perform operation on a null FILE
  • ora-30201 : Unable to load NLS data object
  • ora-27015 : skgfcls: failed to close the file
  • ora-12491 : DBHIGH value does not dominate DBLOW
  • ora-16131 : An error occurred during a Terminal Recovery of the standby.
  • ora-16150 : FINISH recovery performed on another, older standby database
  • ora-24763 : transaction operation cannot be completed now
  • ora-02824 : Request free list is empty
  • ora-09272 : remote os logon is not allowed
  • ora-29520 : name string resolved to a class in schema string that could not be accessed
  • ora-15170 : cannot add entry 'string' in directory 'string'
  • ora-12233 : TNS:Failure to accept a connection
  • ora-36995 : (XSRELGID12) There are duplicate values in the surrogate dimension gid. Use the levelorder option to resolve the ambiguity.
  • ora-16655 : specified target standby database invalid
  • ora-28101 : policy already exists
  • ora-38497 : Expression Filter index does not exist
  • ora-19756 : corrupt block number string found in change tracking file
  • ora-19513 : failed to identify sequential file
  • ora-37028 : (XSMLTRESYNC03) Object workspace object cannot be resynced without modified object workspace object because they share a modified dimension map.
  • ora-30158 : The OCIFileWrite causes the file to exceed the maximum allowed size
  • ora-01507 : database not mounted
  • ora-14163 : subpartition number string: INITRANS value must be less than MAXTRANS value
  • ora-38772 : cannot add datafile 'string' - file could not be created
  • ora-26077 : direct path column array is not initialized
  • 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.