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 15: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;