Oracle sequence problem

Hi there

I need to solve a problem with Oracle sequence-trigger (for generating an "next" value). For empty table everything works fine, but when you are about to issue "insert" statement for a table with previously loaded data in it (say from a .dat file), the next value goes to 1, instead to the next largest in the column. E.G.You have a table with a column that has 10 records from 1 to 10. When you execute insertinto.....values... it creates as a next value 1 instead of 11, next 2 instead of 12 and so on.

Any suggestions?

Thanx

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Mon Oct 25 1999 - 21:34:13 CDT