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 Mike Lewis 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
0
0
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
259
Livia8
Livia8
Kalyan Ganesan
  • Locked
  • Question
ALTER TRIGGER in a PL SQL CODE
Replies
1
Views
112
johnherman
johnherman
Andrzejek
  • Locked
  • Question
Copy Sequences
Replies
6
Views
139
Beilstwh
Beilstwh
tekpr00
  • Locked
  • Question
Alter User sys Error in Oracle 10 , but worked in Oracle 11 1
Replies
1
Views
77
tekpr00
tekpr00
SantaMufasa
  • Locked
  • Question
How can we rename a sequence that another user owns? 1
Replies
7
Views
165
SantaMufasa
SantaMufasa

Part and Inventory Search

Sponsor

Back
Top