The after suspend trigger in this situation will end abnormally, with an exception. It is a good idea to handles any exceptions in your trigger code. The AFTER SUSPEND trigger is an autonomous transaction, meaning that it happens independently of the transaction that fired the trigger. So while the AFTER SUSPEND trigger may end abnormally, the original transaction will stay in suspended mode until you resolve the space issue.
Dig Deeper on Oracle database design and architecture
Have a question for an expert?
Please add a title for your question
Get answers from a TechTarget expert on whatever's puzzling you.