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>
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 DBAReceived on Fri Nov 04 2005 - 16:22:17 CET