What happens if there is no more space available for a new extent in a tablespace?
If there is no more free space available for a new extent to be allocated, and if the automatic data file enhancement is not activated by AUTOALLOCATE, the current transaction terminates and the system issues an error message. If this is an SAP update transaction, the SAP system update is deactivated. For more information about these errors and how to solve them, see Note 3155.
Related Questions
- If the DEFAULT and TEMPORARY tablespace clauses are left out of a CREATE USER command what happens? Is this bad or good?
- What happens if the officer in the case and the charging lawyer disagree over the extent of the necessary file build?
- What happens if the defined default tablespace of a partitioned segment no longer exists?