QUESTION 700

701. A user receives the following error while performing a large volume of inserts into a table:

The issue is resolved by increasing the space quota on the USERS tablespace for the user. But the user
may perform such transaction in the future. You want to ensure that the command waits rather than
produce an error when such an event occurs the next time.
What can you do to achieve this befZ??http://www.2cto.com/kf/ware/vc/" target="_blank" class="keylink">vcmUgcnVubmluZyB0aGUgY29tbWFuZCBpbiB0aGUgZnV0dXJlPzxiciAvPg0K1eK49s7KzOLKx82ouf3U9rzTv9W85MXktu7OqtPDu6e94r7208O7p7Htv9W85KGjtavTw7unPGJyIC8+DQq/ydLU1NrOtMC0vfjQ0NXi0fm1xL270teho8Tj0qrIt7Gjw/zB7rXEtci0/bb4srvKxzxiciAvPg0KtbG3osn61eLR+bXEysK8/sqxsvrJ+tK7uPa07c7zoaM8YnIgLz4NCtTazrTAtLXE1MvQ0NbQo6zE48Tc1/bKssO0wLTKtc/W1eK49qO/PC9wPg0KPHA+PHN0cm9uZz5BLiBTZXQgUkVTVU1BQkxFX1RJTUVPVVQgZm9yIHRoZSBpbnN0YW5jZTwvc3Ryb25nPjwvcD4NCjxwPkIuIFNldCB0aGUgUkVTT1VSQ0VfTElNSVQgUGFyYW1ldGVyIHRvIFRSVUUuPC9wPg0KPHA+Qy4gRW5hYmxlIHRoZSBkYXRhYmFzZSBpbnN0YW5jZSB0byB1c2UgYXN5bmNocm9ub3VzIGNvbW1pdC48L3A+DQo8cD5ELiBTZXQgdGhlIExPR19DSEVDS1BPSU5UX1RJTUVPVVQgcGFyYW1ldGVyIHRvIGEgbm9uemVybyB2YWx1ZSBmb3IgdGhlIGRhdGFiYXNlIGluc3RhbmNlPC9wPg0KPHA+Q29ycmVjdCBBbnN3ZXI6IEE8L3A+DQo8cHJlIGNsYXNzPQ=="brush:sql;"> 当在会话里打开这个功能后(运行 alter session enable resumable timeout 秒, 默认7200).当运行某些sql导致空间不足(表空间用完了)、或已抵达该表/段的 maxextents， 或者 该用户使用此表空间的配额已经用完（原话：Out of space condition, Maximum extents reached condition, Space quota exceeded condition.），此时Oracle将不会报错，而是把 语句挂起，让 dba 在 timeout 所指定的时间范围内解决问题，之后语句又可以继续运行。 这个功能主要是防止因为空间不够的原因导致session failed，