scott@9i > create sequence mysequence1 start with 1 increment by 1 nocache;

Sequence created.

scott@9i > create table t1 (id number);

Table created.

scott@9i > create table t2 (id number);

Table created.

scott@9i > begin
  2  for mag in 1..12 loop
  3  insert into t1 values (mysequence1.nextval);
  4  end loop;
  5  commit;
  6  end;
  7  /

PL/SQL procedure successfully completed.

scott@9i > create sequence mysequence2 start with 1 increment by 1 cache 10;

Sequence created.

scott@9i > begin
  2  for mag in 1..12 loop
  3  insert into t2 values (mysequence2.nextval);
  4  end loop;
  5  commit;
  6  end;
  7  .
scott@9i > /

PL/SQL procedure successfully completed.
 

scott@9i > select mysequence1.currval from dual;

   CURRVAL
----------
        12

scott@9i > select mysequence2.currval from dual;

   CURRVAL
----------
        12


scott@9i > !exp scott/tiger owner=scott file=scott.dmp

Export: Release 9.2.0.4.0 - Production on Thu Jun 9 08:46:58 2005

Copyright (c) 1982, 2002, Oracle Corporation.  All rights reserved.


Connected to: Oracle9i Enterprise Edition Release 9.2.0.4.0 - 64bit Production
With the Partitioning option
JServer Release 9.2.0.4.0 - Production
Export done in US7ASCII character set and AL16UTF16 NCHAR character set
server uses WE8ISO8859P1 character set (possible charset conversion)

About to export specified users ...
. exporting pre-schema procedural objects and actions
. exporting foreign function library names for user SCOTT
. exporting PUBLIC type synonyms
. exporting private type synonyms
. exporting object type definitions for user SCOTT
About to export SCOTT's objects ...
. exporting database links
. exporting sequence numbers
. exporting cluster definitions
. about to export SCOTT's tables via Conventional Path ...
. . exporting table                             T1         12 rows exported
. . exporting table                             T2         12 rows exported
. exporting synonyms
. exporting views
. exporting stored procedures
. exporting operators
. exporting referential integrity constraints
. exporting triggers
. exporting indextypes
. exporting bitmap, functional and extensible indexes
. exporting posttables actions
. exporting materialized views
. exporting snapshot logs
. exporting job queues
. exporting refresh groups and children
. exporting dimensions
. exporting post-schema procedural objects and actions
. exporting statistics
Export terminated successfully without warnings.

scott@9i >  select 'drop '||table_type ||' '||table_name||';' from cat;

'DROP'||TABLE_TYPE||''||TABLE_NAME||';'
------------------------------------------------
drop SEQUENCE MYSEQUENCE1;
drop SEQUENCE MYSEQUENCE2;
drop TABLE T1;
drop TABLE T2;

scott@9i > drop SEQUENCE MYSEQUENCE1;
drop SEQUENCE MYSEQUENCE2;
drop TABLE T1;
drop TABLE T2;

Sequence dropped.

scott@9i >
Sequence dropped.

scott@9i >
Table dropped.

scott@9i >
Table dropped.

scott@9i > !imp scott/tiger fromuser=scott touser=scott file=scott.dmp ignore=y

Import: Release 9.2.0.4.0 - Production on Thu Jun 9 08:50:54 2005

Copyright (c) 1982, 2002, Oracle Corporation.  All rights reserved.


Connected to: Oracle9i Enterprise Edition Release 9.2.0.4.0 - 64bit Production
With the Partitioning option
JServer Release 9.2.0.4.0 - Production

Export file created by EXPORT:V09.02.00 via conventional path
import done in US7ASCII character set and AL16UTF16 NCHAR character set
import server uses WE8ISO8859P1 character set (possible charset conversion)
. . importing table                           "T1"         12 rows imported
. . importing table                           "T2"         12 rows imported
Import terminated successfully without warnings.


scott@9i > select mysequence1.nextval from dual;

   NEXTVAL
----------
        13

scott@9i > select mysequence2.nextval from dual;

   NEXTVAL
----------
        21

create sequence seq1 maxvalue 5 cache 4 cycle;
select seq1.nextval from user_objects where rownum < 9;

1
2
3
4
5
1
2
3