oracle相关,  个人笔记

创建与修改序列

创建序列:
Create Sequence HSC_GROUP_MEMBER_SEQ
Minvalue 10000000000
Maxvalue 99999999999
Start With 10000000000
Increment By 1
Cache 2;
/
------------------------------------------------------------------
修改序列:
Alter Sequence hsc_rec_product_seq Increment By 400000;

Select hsc_rec_product_seq.nextval From Dual;

Alter Sequence hsc_rec_product_seq Increment By 1;
 select hsc_rec_product_seq.nextval from dual;
            修改完成。简单吧

 select hsc_rec_product_seq.nextval from dual;

rm -f auto.07*
rm -f business.07*
rm -f utils.07*
rm -f xmldispatch.07*

cd /usr/WebSphere/AppServer/profiles/AppSrv01/provlog
find ./ -mtime  -n +5 -print -exec rm -f {} \

  find /usr/WebSphere/AppServer/profiles/AppSrv01/provlog -mtime +5 -name "*.*" -exec rm -rf {} \;

rm auto.08-13*
rm auto.08-13*
rm auto.08-13*
rm auto.08-13*
rm auto.08-13*
rm auto.08-13*

留言

您的邮箱地址不会被公开。 必填项已用 * 标注