Rick You sure can -- as long as you can establish SQL*Net connection to the instance on the remote machine. All you have to do is specify "[EMAIL PROTECTED]" either on the command line or in your parameter file.
If the OSs are exectly the same, you can even use direct path inserts Kevin -----Original Message----- [EMAIL PROTECTED] Sent: Wednesday, March 19, 2003 8:24 AM To: Multiple recipients of list ORACLE-L Hi All, I have two (2) Windows 2000 (w2k) machines, one running Oracle 8i at a remote site (WAN connection) and another on my desk running the Oracle client software(no database). Can I, and if so how, use sqlldr on my desktop PC to load data into the remote database. The data file to be loaded and the control file are on my desktop. I do not want to use netmeeting or PC anywhere type programs which I know I can use. Thanks Rick -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services --------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Kevin Toepke INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services --------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).