03-Oracle锁及表分区.pptVIP

* 给已分区的表插入纪录 create table ord_mast( orderno varchar2(5) constraint prim primary key, odate date, vencode varchar2(5) constraint fk_ven references vend_master(vencode), o_status char(1) check(o_status in(p,c)), del_date date)partition by range(orderno)( partition om1 values less than(o010), partition om2 values less than(o020) ) * 给已分区的表插入纪录 insert into ord_mast values(o001,to_date(12-1-96,DD-MM-YY),V001,p,to_date(12-1-97,DD-MM-YY)); insert into ord_mast values(o010,to_date(12-2-99,DD-MM-YY),V002,c,to_date(15-3-99,DD-MM-YY)); insert into ord_mast values(o012,to_date(1