In article <[EMAIL PROTECTED]>, <[EMAIL PROTECTED]> writes: > Thanks, it is working for the mentioned format. > Is there any method for importing directly the spooled file from oracle without > changing the file format into the required format like using tab and newline.
I don't know Oracle, but maybe two named pipes might work: mkfifo pipe1 mkfifo pipe2 oracleexport >pipe1 & mysql db -e "load data infile 'pipe2'" & sed -e whatever pipe1 >pipe2 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]