ORA-01691: unable to extend lob segment XXXXXXXX by 8192 in tablespace USERS

I get the below error when I try to insert data in the database.

ORA-01691: unable to extend lob segment XXXXXX by 8192 in tablespace USERS

I’m using an Oracle database (express 12c version). Googling the error I found that it means that there no more space in the tablespace and you need to increase the dimension of your datafile or the number of datafile you are using. I have 5 datafile of 30 GB and one of them is empty so I don’t understand what the problem is.

Edit

SYSTEM 793,19 800 99,15 32768 2,42

SYSAUX 2203,56 2320 94,98 32768 6,72

UNDOTBS1 48,13 23345 0,21 32768 0,15

USERS 153534,5 30720 499,79 30720 499,79

USERS 153534,5 30720 499,79 30720 499,79

USERS 153534,5 30720 499,79 30720 499,79

USERS 153534,5 30720 499,79 30720 499,79

USERS 153534,5 30720 499,79 30720 499,79


Source: oracle

Leave a Reply