#!/bin/sh
su - oracle -c "sqlplus 'X/X' <<EOF
set timing on
alter table X move partition X compress for oltp;
EOF
">>/tmp/aa.log
select s.partition_name,s.BYTES/1024/1024/1024 gb,s.segment_type from dba_segments s where s.partition_name ='X';
60G的分区,压缩之后剩30G.
select s.partition_name,s.BYTES/1024/1024/1024 gb,s.segment_type from dba_segments s where s.partition_name ='X';
60G的分区,压缩之后剩30G.
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/30491527/viewspace-1982912/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/30491527/viewspace-1982912/