Skip to content
Home » Oracle » How to Resolve ORA-02277: invalid sequence name

How to Resolve ORA-02277: invalid sequence name

ORA-02277

Tried to create a sequence to share with other users, but it failed with ORA-02277.

Reserved Word

SQL> create sequence share;
create sequence share
                *
ERROR at line 1:
ORA-02277: invalid sequence name

Begin with Digit

SQL> create sequence 911;
create sequence 911
                *
ERROR at line 1:
ORA-02277: invalid sequence name

ORA-02277 means that the identifier you chose cannot be used for the sequence name, which is invalid and unqualified for an object name in Oracle database.

Which means, don't use any reserved words, don't use names begin with a digit either.

Solution

To have a qualified object name, you need to conform to the Oracle Database Object Names and Qualifiers.

SQL> create sequence share911;

Sequence created.

For more error patterns, you may refer to the post: How to Resolve ORA-00903: invalid table name.

Leave a Reply

Your email address will not be published. Required fields are marked *