What is a statement failure?
What is a statement failure?
Rating:
A statement failure occurs when there is a logical failure in the handling of a statement in an Oracle program. For example, when all extents of a table (in other words, the number of extents specified in the MAXEXTENTS parameter of the CREATE TABLE statement) are allocated and completely filled with data, a valid INSERT statement cannot insert a row because no space is available. Therefore, the statement fails.
If a statement failure occurs, the Oracle software or operating system returns an error. A statement failure does not require any recovery step. Oracle automatically resolves the statement failure by rolling back the effects of the statement and returning control to the application. The user can execute the statement again after the problem indicated by the error message is corrected. For example, if insufficient extents are allocated, the database administrator (DBA) needs to allocate more extents so that the user's statement can be executed.
Rating:
Other articles
- What is the Import utility?
- What is backup retention policy?
- What is the direct path Export?
- What is Recovery Manager (RMAN)?
- How is an Oracle database opened?