Can NOPARTITION Clause Be Used When Creating Sequence (Doc ID 2642798.1)

Last updated on APRIL 17, 2023

Applies to:

Goal

Can NOPARTITION clause be used when create sequence?
--------------

SQL> CREATE SEQUENCE  "OWNER"."Sequence_Name"  MINVALUE 1000000 MAXVALUE 9999999 INCREMENT BY 1 START WITH 1000000 NOCACHE  ORDER  CYCLE  NOPARTITION ;

SQL> select * from user_sequences;
SEQUENCE_NAME
----------------------------------------------------------------------------------------------------
MIN_VALUE  MAX_VALUE INCREMENT_BY C O CACHE_SIZE LAST_NUMBER PARTITION_COUNT S K MKS_SEQ_SMBC_SPNCWL
---------- ---------- ------------ - - ---------- ----------- --------------- - -
  1000000    9999999            1 Y Y          0     1000000                 N N

--------------

Solution

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.