Set database resumable

You can use bellow command to make your session resumable. Which means that if your session hit space limited issue, for example, the data file do not have more space and it can not be auto extended, then your session will not exit with error. It will only hung there waiting for you to resolve the issue. After that every thing can continue.

alter session enable resumable;

 

Also you can set RESUMABLE_TIMEOUT initiate parameter to affect the whole instance.