Q

Help with AFTER SUSPEND trigger

In 9i, when using resumable space allocation, you have an AFTER SUSPEND trigger defined. If the original transaction has a space allocation problem and the trigger fires, then the trigger has a space allocation problem trying to write some rows into an audit table, what will happen to the trigger and the original transaction?
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.
This was first published in October 2003

Dig deeper on Oracle database design and architecture

Pro+

Features

Enjoy the benefits of Pro+ membership, learn more and join.

Have a question for an expert?

Please add a title for your question

Get answers from a TechTarget expert on whatever's puzzling you.

You will be able to add details on the next page.

0 comments

Oldest 

Forgot Password?

No problem! Submit your e-mail address below. We'll send you an email containing your password.

Your password has been sent to:

SearchDataManagement

SearchBusinessAnalytics

SearchSAP

SearchSQLServer

TheServerSide

SearchDataCenter

SearchContentManagement

SearchFinancialApplications

Close