Hello to all, I was working with Oracle 11gR2 doing some heavy dml when got an error about tablespace Users ran out of space because my database was assigned to that tablespace. The solution was to add another datafile so the transactions could finish but I was thinking was would happen if there was no more space to create more files to store the data?
According to manuals the transactions that couldn't finish would be rolledback but what should I do to contiue with the operations in case of an emergency?
Any comments would be useful.