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
Title: Message
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 spool, asks for a
file name give the file name you want, later type the select command from
which you want the data.
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
Hi,
Could any one of you suggest me a better way to bump the data in oracle 7.3 to
mysql 4.0 classic.
Thanks,
Narasimha
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Sent: Tue 9/28/2004 8:58 PM
To: martin fasani
Sorry in advance for the dumb newbie question but . . . I'm using a
content management system and want to avoid the hassle of entering data
by hand when I've already got it in a delimited text file. I get the
basic concept of using mysqlimport. However, the source file's data
doesn't match the
If I understand correctly, your text file does not have an ID for each
row, but the table does have an ID column. Good. Your table should
have the record ID column defined as AUTO_INCREMENT. Something like
CREATE TABLE table_name (
ID int NOT NULL PRIMARY KEY AUTO_INCREMENT,
other
I have data that is in a progress database. I need to get
a copy of the data into my mysql database. What would
be the best approach ? I can dump the data in any specific
format, so.
Never tried ODBC with Progress (8.2C12), so don't know if
that can/will work.
thanks,
Darryl
--
MySQL
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On Tue, 27 May 2003 11:17:34 +0200, Emiliano Rustighini wrote:
I can ask for the data in any data format, but I would like to get some
advice on what is best to ask for.
I have found text format to be the most flexible method for transferring
11 matches
Mail list logo