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:

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

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

No comments: