ORA-1691: unable to extend lobsegment

ERROR:
ORA-1691: unable to extend lobsegment DWADM.SYS_LOB0000093603C00012$$ by 128 in tablespace STS_01
ORA-1691: unable to extend lobsegment DWADM.SYS_LOB0000093603C00012$$ by 128 in tablespace STS_01
ORA-1691: unable to extend lobsegment DWADM.SYS_LOB0000093603C00012$$ by 128 in tablespace STS_01

SOLUTION:

Use ALTER TABLESPACE ADD DATAFILE statement to add one or more files to the tablespace indicated.

alter tablespace sts_01 add datafile ‘/oradata/DB/db/sts_03.dbf’ size 100m autoextend on next 100m maxsize 8g;

Nagulu Polagani

"We are all apprentices in a craft where no one ever becomes a master."