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]

Reply via email to