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

NZE-29225: Certificate already installed.

1 Answers  


ORA-16519: the resource handle is invalid

1 Answers  


RMAN-06483: changed datafile copy expired

1 Answers  


ORA-39120: Table string can't be truncated, data will be skipped. Failing error is: string

1 Answers  


EXP-00087: Problem with internal hash table of schema/table names

1 Answers  






ORA-02435: cannot disable unique(string) - unique key not defined for table

1 Answers  


PCC-02427: Expression is not of the correct character string type

1 Answers  


ORA-16171: RECOVER...FINISH not allowed due to gap for thr string, seq string-string

1 Answers  


ORA-22902: CURSOR expression not allowed

1 Answers  


ORA-02077: selects of long columns must be from co-located tables

1 Answers  


NID-00452: Succesfully changed database ID.

1 Answers  


ORA-19714: length for generated name longer than string

1 Answers  


Categories