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,
[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
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 "\t" with empty string. 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 (b
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
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
