How Oracle Rename Sequence
To rename a sequence, we should RENAME TO statement to rename it, but you have to login as the object's owner. For example: SQL> show… Read More »How Oracle Rename Sequence
Sequence
Oracle RENAME Statement
RENAME Syntax For convenience, Oracle provide RENAME statement to change some types of object's name. The syntax is as: RENAME old_name TO new_name; There're only… Read More »Oracle RENAME Statement
How Oracle Reset Sequence
Reset a Sequence with Original NEXTVAL There're two way to reset sequence to exact number you want in Oracle: 1. Start Sequence to Exact Number… Read More »How Oracle Reset Sequence
How to Resolve ORA-08002: sequence CURRVAL is not yet defined in this session
ORA-08002 ORA-08002 means that you don't have any sequence value cached in your session, so you can't check the current value (CURRVAL) of the sequence… Read More »How to Resolve ORA-08002: sequence CURRVAL is not yet defined in this session