My Oracle Support Banner

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

Last updated on MARCH 11, 2020

Applies to:

Oracle Database - Enterprise Edition - Version 12.1.0.2 and later
Information in this document applies to any platform.

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

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Goal
Solution
References


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