10 2017 档案

Oracle锁表与解锁
摘要：--锁表查询SQLSELECT object_name, machine, s.sid, s.serial#,s.* FROM gv$locked_object l, dba_objects o, gv$session s WHERE l.object_id = o.object_id AND l. 阅读全文
posted @ 2017-10-20 16:12 Capp 阅读(778) 评论(0) 推荐(0)
oracle按时间分区以及自动分区
摘要：(1) 创建按时间分区的表 create table temp_workdate( WORKDATE date)PARTITION BY RANGE (WORKDATE)( partition P_20171020 values less than (TO_DATE(' 2017-10-20 23: 阅读全文
posted @ 2017-10-20 16:09 Capp 阅读(1350) 评论(0) 推荐(0)