Re: Using Sqlloader towards an distant DB.

"Jan-Rune" <JanRune.Sorheim_at_netcom-gsmnospam.no> wrote in message news:<9h9p1l$b9g$1_at_lise.netcom.no>...
> Hello.
>
> I have 2 servers (Server A and server B) running HP-UX 11. On both these
> servers I have installed Oracle 8.0.6. On Server B I have several files that
> I would like to load into server A by using Sqlloader. In other words I
> would like to start Sqlloader, read the files located on Server B and put
> the content into the Oracle database on Server A.
>
> Is there a parameter that I can set when running the command : " sqlload
> userid=user/passwd control=load_sbs_rnw_bsc.ctl log=load_sbs_rnw_bsc.log "
> that enabels me to direct the loading to an other server? Or is there
> anything I can set in the .ctl file to do the same thing?
>
> Jan-Rune
Hello,
1. Define an entry in the file tnsnames.ora on Server B which would point to

   Oracle database on server A
2. set a variable TWO_TASK which would be the tnsnames.ora service entry that

   you created in step 1
3. Run sqlload
It would connect to the database on Server A and load records

Bhooshan Received on Wed Jun 27 2001 - 15:06:10 CEST