Confluence- Transaction rolled back because it has been marked as rollback-only

Error said:

...but this error was hidding the real error which I found in the confluence log files:
unable to extend lob segment confluence

At this point I suspected the database was full, a little Google searching led me to find some stuff about oracle. Here are the steps I took to correct the issue:

1. log in to the server via vpn
2. open the oracle db admin console
3. the dashboard in oracle listed 1 error - Users table 97% full
4. changed the space allocation on the users table from 50mb to 100mb and set it to auto increment by 10mb up to 8gb.