How to fix : unable to extend segment by 8 in undo tablespace?

Question

I'm trying to add 10m data to my database table and at about 3,5m it stopped and I got the error

unable to extend segment by 8 in undo tablespace.

I've never encountered that before and I have no idea how to fix it.

I'm running my scripts through sqlplus.

My code

CREATE TABLE ADDRESS (
ID_ADDRESS INTEGER NOT NULL,
STREET VARCHAR2 (20) NOT NULL,
HOUSE_NUMBER NUMBER(10) NOT NULL,
FK_ID_CITY NUMBER(10) NOT NULL
);

filling code

EXEC ui.fillAddress(10000000);

the solution i tried but didn't work

Answer 1

Oracle uses his own disk space allocation system, which lies on top of (or, under, depending how you view it) the OS filesystem. So, your disk may have lots of space, but your database is not configured to be allowed to use that disk space.