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 <table> disable constraint <constraint>;
+
alter table table_name disable constraint <constraint>;
 
* enable constraint
 
* enable constraint
alter table <table> enable constraint <constraint>;
+
alter table table_name enable constraint <constraint>;
 
* empty table and release space
 
* empty table and release space
truncate table <table> DROP STORAGE;
+
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;