ORA-22875: cannot drop primary key of an object table whose
object identifier is primary key based



ORA-22875: cannot drop primary key of an object table whose object identifier is primary key based..

Answer / guest

Cause: An attempt to drop the primary key of an object table
which has a primary key based object identifier

Action: Remove the drop primary key clause

Please add more information about this Error

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Oracle Errors Interview Questions

ORA-32141: get method does not match the type of the parameter

1 Answers  


QSM-00771: the specified SQL statement cannot be stored in the workload because it has no valid table references

1 Answers  


ORA-01555: snapshot too old: rollback segment number string with name "string" too small

1 Answers  


ORA-12031: cannot use primary key columns from materialized view log on "string"."string"

1 Answers  


QSM-00505: syntax error

1 Answers  


ORA-00091: LARGE_POOL_SIZE must be at least string

1 Answers  


ORA-31667: parameter name can not be defaulted

1 Answers  


ORA-12484: invalid OS label

1 Answers  


ORA-14646: Specified alter table operation involving compression cannot be performed in the presence of usable bitmap indexes

1 Answers  


ORA-21521: exceeded maximum number of connections in OCI (object mode only)

1 Answers  


DGM-16917: Unable to shut down instance "string".

1 Answers  


NZE-28846: No private key

1 Answers  


Categories