ORA-02344: cannot revoke execute on a type with table dependents



ORA-02344: cannot revoke execute on a type with table dependents..

Answer / guest

Cause: An attempt was made to revoke execute on a type that
has dependents.

Action: Drop all table(s) depending on the type, then retry
the operation, or use the FORCE option.

Please add more information about this Error

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Oracle Errors Interview Questions

ORA-12950: SYSTEM tablespace specified as default permanent tablespace

1 Answers  


ORA-22979: cannot INSERT object view REF or user-defined REF

1 Answers  


NNL-01000: SERVER FAILURE responses received: number

1 Answers  


PLS-00332: "string" is not a valid prefix for a qualified name

1 Answers  


DRG-13306: 'len' attribute value must be in the range string..string, at line string

1 Answers  






NZE-28765: Data method list does not exist.

1 Answers  


ORA-32314: REFRESH FAST of "string"."string" unsupported after deletes/updates

1 Answers  


ORA-12341: maximum number of open mounts exceeded

1 Answers  


QSM-01020: materialized view, string, is ineligible

1 Answers  


LSX-00134: attribute "~1S" has invalid qualification "~2S"

1 Answers  


DRG-12211: section or section id string does not exist

1 Answers  


NID-00441: All previous backups and archived redo logs for this database are unusable.

1 Answers  


Categories