Difference between revisions of "Oracle"
From Alessandro's Wiki
(Created page with " * 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_segm...") |
|||
Line 7: | Line 7: | ||
select segment_name,segment_type,bytes ,max_size from user_segments ORDER BY bytes DESC | select segment_name,segment_type,bytes ,max_size from user_segments ORDER BY bytes DESC | ||
* disable constraint | * disable constraint | ||
alter table | alter table table_name disable constraint <constraint>; | ||
* enable constraint | * enable constraint | ||
alter table | alter table table_name enable constraint <constraint>; | ||
* empty table and release space | * empty table and release space | ||
truncate table | truncate table table_name DROP STORAGE; |
Latest revision as of 14:13, 11 December 2013
- 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 table_name disable constraint <constraint>;
- enable constraint
alter table table_name enable constraint <constraint>;
- empty table and release space
truncate table table_name DROP STORAGE;