Re: User Session Question

From: Sybrand Bakker <gooiditweg_at_nospam.demon.nl>
Date: Fri, 04 Nov 2005 16:22:17 +0100
Message-ID: <v2vmm1hom9f9cgarlmk0ceik9v36jgcq6u_at_4ax.com>


On 4 Nov 2005 06:54:54 -0800, "Coach" <coach_24_at_hotmail.com> wrote:

>I am trying to limit the number of user sessions that I am creating by
>calling sql loader. I have several thousand files that are being
>loaded daily using sql loader, however, a new control file needs to be
>created for each file, therefore I can't list multiple INFILEs in one
>control file. Is there a way to call sql loader without creating a
>different user session every time sql loader is called?

No, as sqlloader is intended as a commandline product. You'll need to rethink your strategy or learn to live with it.

--
Sybrand Bakker, Senior Oracle DBA
Received on Fri Nov 04 2005 - 16:22:17 CET

Original text of this message