alter sequence start with ##

  • From: Jeremy Schneider <jeremy.schneider@xxxxxxxxxxxxxx>
  • To: Oracle-L <oracle-l@xxxxxxxxxxxxx>
  • Date: Sun, 17 Oct 2010 11:35:58 -0500

nice error message in SQL Developer:

alter sequence tmpses2id start with 13;


Error starting at line 5 in command:
alter sequence tmpses2id start with 13
Error report:
SQL Error: ORA-02283: cannot alter starting sequence number
02283. 00000 -  "cannot alter starting sequence number"
*Cause:    Self-evident.
*Action:   Don't alter it.


-- 
http://www.ardentperf.com
+1 312-725-9249

Jeremy Schneider
Chicago

Other related posts:

  • » alter sequence start with ## - Jeremy Schneider