Re: about sql*loader load sequence #

From: hpuxrac <johnbhurley_at_sbcglobal.net>
Date: 1 May 2007 14:07:30 -0700
Message-ID: <1178053650.502126.59710@q75g2000hsh.googlegroups.com>

On May 1, 4:47 pm, esthershe..._at_yahoo.com wrote:
> 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.

Take a look at http://asktom.oracle.com do a search and include the words sequence and sqlldr ...

I am sure you will get some good examples Received on Tue May 01 2007 - 16:07:30 CDT