Oracle
From Alessandro's Wiki
- check stats enabled:
SELECT DBMS_STATS.get_prefs('PUBLISH') FROM dual;
- list of tables ordered by size
select segment_name,segment_type,bytes ,max_size from user_segments ORDER BY bytes DESC
- disable constraint
alter table
disable constraint <constraint>;- enable constraint
- empty table and release space