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

TNS-12546: TNS:permission denied

2 Answers  


KUP-04021: field formatting error for field string

1 Answers  


PCC-02338: structure contains a nested struct or union

1 Answers  


ORA-34210: (MXCHGDCL18) You cannot change workspace object to a dimension composite because one or more surrogates has been defined for it.

1 Answers  


PCC-02135: CMD-LINE: User asked for help

1 Answers  






ORA-12592: TNS:bad packet

1 Answers   BoCom,


PLS-00657: Implementation restriction: bulk SQL with associative arrays with VARCHAR2 key is not supported.

1 Answers  


RMAN-06004: ORACLE error from recovery catalog database: string

1 Answers  


PROT-00005: Clusterware is not running properly

1 Answers  


ORA-31014: Attempted to delete the root container

1 Answers  


ORA-16542: unrecognized operation

1 Answers  


NZE-28884: invalid cipher suite

1 Answers  


Categories