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

RMAN-00558: error encountered while parsing input commands

1 Answers  


RMAN-20002: target database already registered in recovery catalog

1 Answers  


NNO-00604: disabling all request processing

1 Answers  


ORA-30354: Query rewrite not allowed on SYS relations

1 Answers  


ORA-19589: %s is not a snapshot or backup controlfile

1 Answers  






ORA-13442: GeoRaster metadata SRS error

1 Answers  


ORA-09366: Windows 3.1 Two-Task driver unable to allocate shared memory

1 Answers  


SQL*Loader-00122: Invalid skip_index_maintenance option

1 Answers  


ORA-32407: cannot exclude new values when materialized view log includes new values

1 Answers  


ORA-28031: maximum of string enabled roles exceeded

2 Answers  


ORA-13463: error retrieving GeoRaster data: string

1 Answers  


ORA-01095: DML statement processed zero rows

1 Answers  


Categories