User-Agent: Microsoft-Outlook-Express-Macintosh-Edition/5.02.2022 Subject: newbie ? on sequence #'s From: Robin Boscia Newsgroups: comp.databases.oracle Message-ID: Mime-version: 1.0 Content-Type: text/plain; charset="US-ASCII" Content-transfer-encoding: 7bit Lines: 17 Date: Sun, 11 Nov 2001 07:15:32 GMT NNTP-Posting-Host: 24.56.44.23 X-Complaints-To: abuse@home.net X-Trace: news1.rdc1.az.home.com 1005462932 24.56.44.23 (Sat, 10 Nov 2001 23:15:32 PST) NNTP-Posting-Date: Sat, 10 Nov 2001 23:15:32 PST Organization: Excite@Home - The Leader in Broadband http://home.com/faster we have a production machine & a test machine with the data being used for a ticketing system. we keep some data on the test machine for our use, so every so often, i do an export & an import of that data. once i move the data to the new machine, i run scripts to enable constraints, check invalid packages, etc. i however am having a ??? on my sequences. once the data is on the new machine, if i input a new ticket, via my ticket application gui, it does not sequence correctly. the tickets start back at 1. is there an easy way to start at the next #? this affects quite a few tables..... thanks! robin