You should be able to use sequence.nextval in SQL*Loader. Check the docs,
either hardcopy
or at http://technet.oracle.com.
Hth,
--
Sybrand Bakker, Oracle DBA
mc <postbus_at_claver.demon.nl> wrote in message
news:937332173.18173.0.pluto.c3adfab1_at_news.demon.nl...
> I need to give a batch of records an unique upload id when I load it with
> Loader.
> At this moment I have given a column as default the Oracle user so I can
> update this column with a to_char converted number from a sequence. This
is
> usable in a multi user environment. But I have the problem that I have a
> multi user environment with only 1 Oracle user (of course a supid way but
I
> am not allowed to create more users) How can I solve my problem.
> Marcos
>
>
Received on Tue Sep 14 1999 - 14:08:36 CDT
