create sequence S_QID
minvalue 1
maxvalue 999999999999999999999999999
start with 200901010001
increment by 1
cache 20;本来一直正常运行,今天服务器突然重新从 200901010001 开始获取。请问是什么原因?
minvalue 1
maxvalue 999999999999999999999999999
start with 200901010001
increment by 1
cache 20;本来一直正常运行,今天服务器突然重新从 200901010001 开始获取。请问是什么原因?
SELECT OBJECT_NAME,CREATED FROM DBA_OBJECTS WHERE OBJECT_TYPE='SEQUENCE' AND OWNER='XXX';