Showing posts with label ORA-22971: invalid datatype for PRIMARY KEY-based object identifier. Show all posts
Showing posts with label ORA-22971: invalid datatype for PRIMARY KEY-based object identifier. Show all posts

Friday, 13 April 2012

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

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

Cause: When creating an object view, the datatype of an expression in the WITH OBJECT OID clause is not allowed for PRIMARY KEY-based OID.

Action: Replace the expression with one of appropriate scalar datatype.