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



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

Answer / guest

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.

Please add more information about this Error

Is This Answer Correct ?    0 Yes 2 No

Post New Answer

More Oracle Errors Interview Questions

EXP-00070: attempt to free unallocated memory

1 Answers  


QSM-01015: GROUP BY clause has non-columns

1 Answers  


ORA-30102: 'string' is not in the legal range for 'string'

1 Answers  


TNS-12677: Authentication service not supported by database link

1 Answers  


NID-00134: Datafile "string" is not consistent

1 Answers  






ORA-12489: default label not within clearance range

1 Answers  


NPL-00313: requested form string does not match actual form string

1 Answers  


ORA-01317: Not attached to a Logminer session

1 Answers  


ORA-24071: cannot perform operation string, queue table string is being migrated

1 Answers  


ORA-06264: NETNTT: data protocol error

1 Answers  


RMAN-12013: multiple records for string channel number found in catalog

1 Answers  


NZE-28770: Data source is already initialized.

1 Answers  


Categories