You couldn't use UTL_FILE, unless there is a mechanism for the Unix machine to see the filesystem of the NT machine - and if there was, it would be easier to run SQL*Loader on Unix.
What do you have on your client machine? I assume that the Oracle client is installed. Therefore, you can write a simple program to format your text file into DML statements, then just run these in SQL*Plus. Alternatively, it would be simple in Perl or Java to write a program that parsed the text file and fired off INSERT statements to Oracle in one go, this would be easier if you need to do this a lot. Or use Samba on Unix, to copy the text file across from NT to Unix, then you can use UTL_FILE or SQL*Loader or whatever tool you want to load the data. HTH, g -----Original Message----- Sent: Tuesday, October 02, 2001 11:14 PM To: Multiple recipients of list ORACLE-L Hi listers, I want to insert a text file in my client machine (Win NT) into emp (empno,ename, salary) table in unix machine from my client. I don't have sqlloader in my machine (client). How to do that ? Can we used utl_file package ? If yes , please give an example because I'm new for utl_file package. The columns in text file are (empno, ename, salary) : 1111 Aaaaaaaaa 3000 2222 Bbbbbbbbb 5000 3333 Ccccccccc 4000 Thanks for any clue. Aldi _________________________________________________________________ Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Aldi Barco INET: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- 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.com -- Author: Guy Hammond INET: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- 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).
