oracle记录2 （收缩表空间）

1.resize表空间 

参考：https://blog.csdn.net/csethcrm/article/details/52181212

select 'alter database datafile ''' || a.file_name || ''' resize ' ||
round(a.filesize - (a.filesize - c.hwmsize - 100) * 0.8) || 'M;',
a.filesize || 'M' as "数据文件的总大小",
c.hwmsize || 'M' as "数据文件的实用大小"
from (select file_id, file_name, round(bytes / 1024 / 1024) as filesize
from dba_data_files) a,
(select file_id, round(max(block_id) * 8 / 1024) as HWMsize
from dba_extents
group by file_id) c
where a.file_id = c.file_id
and a.filesize - c.hwmsize > 100;

2.日期转换

字段是varchar2类型。但是存入的却是17-3月 -17 03.00.01.000000000 下午

ALTER SESSION SET nls_date_language = 'SIMPLIFIED CHINESE';
select to_char(cast(cast('17-3月-17 03.00.01.000000000 下午' as timestamp) as date),'yyyy-mm-dd hh24:mi:ss')
from dual