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
Can you post one or 2 sample lines from alarm.txt ?
Regards,
Andrey
P.S.
(i am not on [EMAIL PROTECTED] so add me to the CC:)
[EMAIL PROTECTED] wrote:
Hi,
I tried with the spool option to get the data from the tables in the oracle.
For this go to pl/sql editor, go to file menu, select
Title: Re: importing data into mysql from oracle using a text file
The sample lines are like this in
alarm.txt
ARRIVED DETECTED
NAME
TYPE ALARMLEVEL V DISCLOSED CATEGORY_NUM
EVENTID
Hi,
I did imported your data im my server but I had to do some changes to sample.txt.
I have replaced in a text editor tab\t with empty string. tab is a real tab
while \t is just a text. Additional change was to replace \n (which is text but not
newline with empty string). The I did the following
[mailto:[EMAIL PROTECTED]
Sent: Thu 9/30/2004 2:01 AM
To: Lakshmi NarasimhaRao (WT01 - TELECOM SOLUTIONS)
Cc: [EMAIL PROTECTED]
Subject: Re: importing data into mysql from oracle using a text file
Hi,
I did imported your data im