Thanks for the question, israel.
Asked: April 29, 2019 - 4:51 pm UTC
Last updated: April 30, 2019 - 3:24 am UTC
Version: 18c XE
Viewed 1000+ times
You Asked
hi
i have a problem when i am trying to drop tables i get this error
Error dropping CITIZEN:
ORA-04098: trigger 'SYS.DELETE_ENTRIES' is invalid and failed re-validation
thanks
israel
and Connor said...
Someone has created a trigger at database level to fire when you try to drop an objects, and that *trigger* (not your drop) is failing.
That is a standard trigger in XE, so if it's invalid, then something gone very wrong.
Is it possible you have inadvertently dropped a table called: SYSTEM.SQLPLUS_PRODUCT_PROFILE ?
Is this answer out of date? If it is, please let us know via a Comment