Decrease SQL database size [Oracle] - ORA-12953

Question

I am working on a local Oracle XE database. But it has reached the 11 GB limit.

ORA-12953: The request exceeds the maximum size allowed for the database, which is 11 GB.

It turns out I deleted several table records and still when I try to make one update in another table gives the same error, even having already deleted several things. I read some things that Oracle has already allocated this space, ie even without data it is keeping the allocated space.

Do you have a command that can fix this?

Answer 1

You can change the tables to wipe the data with:

alter table mytable enable row movement

or

alter table mytable shrink space cascade

I put in the Github for future reference.

Source.