Re: SQL*Loader question

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: Mon, 4 Dec 2000 22:53:33 +0100
Message-ID: <90h5ae$1778u$7@ID-62141.news.dfncis.de>

Just use userenv('sessionid'), as that already automatically and monotously increments. No need to develop your own mechanism, providing you'r not connected as SYS

Hth,

Sybrand Bakker, Oracle DBA

<manu_b_at_my-deja.com> wrote in message news:90gidu$6mf$1_at_nnrp1.deja.com...
> Hi everybody,
>
> I would like to be able to load multiples text files into the same
> table and simultaneously.
> After, a pl/sql package is manipulating the data from the temporary
> table to the live tables.
> The problem is to associate a uniq session identifier to each sqlload
> session (not to each rows to be loaded) and populate the temporary
> table with this session id (as a constant).
> All rows in a session will have the same session id.
> The session_id should be from an Oracle sequence.
>
> Any powerful and reliable idea will be appreciated.
>
> Thanks in advance.
>
> Emmanuel
>
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
Received on Mon Dec 04 2000 - 15:53:33 CST