Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Chris Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Alter sequence

Status
Not open for further replies.
ofsouto

ofsouto

Programmer
Apr 29, 2000
185
BR
When I install a new application in a client, I need to load some tables with initial registers.
After load tables I need to drop some sequences and create them again with another start number
because I don't know how to do this automaticaly.
I create the load scritp with TOAD tool that don't put ident_xxxx.nextval on sequence attribute.
 
Sort by date Sort by votes
In order to reset the starting number, you have to drop and recreate the sequences. You cannot do this using ALTER SEQUENCE.
Thomas V. Flaherty Jr.
Birch Hill Technology Group, Inc.
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

Livia8
  • Locked
  • Question
Alternative to "locate" command
Replies
0
Views
493
Livia8
Livia8
Kalyan Ganesan
  • Locked
  • Question
ALTER TRIGGER in a PL SQL CODE
Replies
1
Views
162
johnherman
johnherman
Andrzejek
  • Locked
  • Question
Copy Sequences
Replies
6
Views
200
Beilstwh
Beilstwh
tekpr00
  • Locked
  • Question
Alter User sys Error in Oracle 10 , but worked in Oracle 11 1
Replies
1
Views
119
tekpr00
tekpr00
SantaMufasa
  • Locked
  • Question
How can we rename a sequence that another user owns? 1
Replies
7
Views
250
SantaMufasa
SantaMufasa

Part and Inventory Search

Sponsor

Back
Top