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-09952: scgcmn: lk_open_convert unexpected return: open failed

1 Answers  


RMAN-06012: channel: string not allocated

1 Answers  


ORA-38450: error computing a stored attribute for the expression set.

1 Answers  


QSM-02096: mv references a named view

1 Answers  


ORA-01776: cannot modify more than one base table through a join view

1 Answers  






ORA-29905: method string does not exist in type string.string

1 Answers  


DRG-50603: unrecognized operation code string

1 Answers  


ORA-12205: TNS:could not get failed addresses

1 Answers  


ORA-24357: internal error while converting from to OCIDate.

1 Answers  


NZE-29027: Error in entropy collection

1 Answers  


ORA-04934: unable to obtain the current sequence number

1 Answers  


ORA-12060: shape of prebuilt table does not match definition query

1 Answers  


Categories