摘要:
--锁表查询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. 阅读全文
摘要:
(1) 创建按时间分区的表 create table temp_workdate( WORKDATE date)PARTITION BY RANGE (WORKDATE)( partition P_20171020 values less than (TO_DATE(' 2017-10-20 23: 阅读全文