Thursday, September 6, 2012

java.sql.SQLException: ORA-01653: unable to extend table BLA by 8 in tablespace BLU

This query works like a breeze to find out the FAT tables:

http://stackoverflow.com/questions/264914/how-do-i-calculate-tables-size-in-oracle


once you discover the FAT tables, run a
truncate table BLA;

you might have to disable FK constraints (remember to reenable again)



No comments: