2012년 5월 27일 일요일

orcle_ sequence 변경

SELECT BOARDCONFIG_UID__SEQ.NEXTVAL FROM DUAL;
SELECT MAX(UID_)+1 FROM BOARDCONFIG;
DROP SEQUENCE TPWADM.BOARDCONFIG_UID__SEQ;
CREATE SEQUENCE TPWADM.BOARDCONFIG_UID__SEQ
    START WITH 35475
    INCREMENT BY 1
    MAXVALUE 999999999999999999999999
    MINVALUE 1
    NOCYCLE
    CACHE 20
    NOORDER;

댓글 없음:

댓글 쓰기