ORA-22975: cannot create a PRIMARY KEY-based REF to this
object view



ORA-22975: cannot create a PRIMARY KEY-based REF to this object view..

Answer / guest

Cause: The object view specified in the MAKE_REF function
does not have a PRIMARY KEY-based object identifier. A
PRIMARY KEY-based REF cannot be created for such a view.

Action: Specify an object view that has a PRIMARY KEY-based
object identifier in the MAKE_REF function.

Please add more information about this Error

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Oracle Errors Interview Questions

ORA-14262: new subpartition name must differ from the old subpartition name

1 Answers  


ORA-14005: missing RANGE keyword

1 Answers  


ORA-14104: RECOVERABLE/UNRECOVERABLE may not be specified for partitioned tables/indices

1 Answers  


ORA-06548: no more rows needed

1 Answers  


NZE-28828: invalid identity type passed

1 Answers  


ORA-00384: Insufficient memory to grow cache

1 Answers  


IMG-00522: invalid format for parameter value

1 Answers  


ORA-09856: smpalo: vm_allocate error while allocating pga.

1 Answers  


PLS-00315: Implementation restriction: unsupported table index type

1 Answers  


ORA-02035: illegal bundled operation combination

1 Answers  


ORA-36182: (XSAGGR09) Could not locate a value for variable number in measure dimension workspace object.

1 Answers  


NID-00417: Change of database ID failed.

1 Answers  


Categories