Oracle - Create sequance

-----------------------------------------------
-- Export file for user SAMPLEUSER --
-----------------------------------------------

spool s070614.log

prompt
prompt Creating sequence IEBKNIFE_SEQ
prompt ==============================
prompt
create sequence SAMPLEUSER.IEBKNIFE_SEQ
minvalue 1
maxvalue 9999999
start with 2541
increment by 1
cache 20
cycle;

prompt
prompt Creating sequence IEBPS_SEQ
prompt ===========================
prompt
create sequence SAMPLEUSER.IEBPS_SEQ
minvalue 1
maxvalue 9999999
start with 240753
increment by 1
cache 20
cycle;

prompt
prompt Creating sequence SAMPLEUSER_SEQ
prompt ===========================
prompt
create sequence SAMPLEUSER.SAMPLEUSER_SEQ
minvalue 1
maxvalue 9999
start with 2021
increment by 1
cache 20
cycle;

prompt
prompt Creating sequence SAMPLEUSER_UNITPACK
prompt ================================
prompt
create sequence SAMPLEUSER.SAMPLEUSER_UNITPACK
minvalue 1
maxvalue 1295
start with 61
increment by 1
cache 20
cycle;

prompt
prompt Creating sequence SCHEDULE_SEQ
prompt ==============================
prompt
create sequence SAMPLEUSER.SCHEDULE_SEQ
minvalue 1
maxvalue 9999999
start with 1
increment by 1
nocache;

prompt
prompt Creating sequence TBL_SEQ
prompt =========================
prompt
create sequence SAMPLEUSER.TBL_SEQ
minvalue 1
maxvalue 999999999999999999
start with 239472
increment by 1
cache 20
cycle;

prompt
prompt Creating sequence TOL_SEQ
prompt =========================
prompt
create sequence SAMPLEUSER.TOL_SEQ
minvalue 1
maxvalue 9999999
start with 2874463
increment by 1
cache 20
cycle;


spool off

댓글 없음:

댓글 쓰기