Re: User Session Question

Coach 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?

If 10g look at DBMS_SCHEDULER.

If looking for an example of writing control files on the fly look in Morgan's Library at www.psoug.org. Click on UTL_FILE and scroll down.

-- 
Daniel A. Morgan
http://www.psoug.org
damorgan_at_x.washington.edu
(replace x with u to respond)