about sql*loader load sequence #

From: <esthershensh_at_yahoo.com>
Date: 1 May 2007 13:47:10 -0700
Message-ID: <1178052430.791774.15000@q75g2000hsh.googlegroups.com>

Hi,

I'm new in Oracle. I have a question for sql*loader.

If I had a columnA in table , I need to load sequence number into that columnA.

I know I could use sequence option to load, but there is no way to reset the sequence if the number reach some high value. Or if I need load data every month, the next load want to know the last value ..

the only way is create sequence in database, and reference sequence in load control file.

Am I right ? Want to get some suggestion from experienced DBA.. Thanks. Received on Tue May 01 2007 - 15:47:10 CDT