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

QSM-02009: non-inner join

1 Answers  


ORA-02705: osnpol: polling of communication channel failed

1 Answers  


ORA-13372: failure in modifying metadata for a table with spatial index

1 Answers  


ORA-01487: packed decimal number too large for supplied buffer

1 Answers  


ORA-30571: invalid SEGMENT SPACE MANAGEMENT clause

2 Answers  


LSX-00201: contents of "~S" should be elements only

1 Answers  


PLS-00309: with %%LAST attribute, 'string' must be a variable of an enumerated type

1 Answers  


PCB-00217: OCCURS INDEXED clause not allowed for host variable "string"

1 Answers  


NPL-00410: incoming ASN.1 value too large (string octets) to store locally

1 Answers  


PLS-00410: duplicate fields in RECORD,TABLE or argument list are not permitted

1 Answers  


ORA-29281: invalid mode

1 Answers  


ORA-02397: exceeded PRIVATE_SGA limit, you are being logged off

1 Answers  


Categories