Skip navigation links

MySQL Forums :: Oracle :: export data from oracle to mysql with sqlplus


Advanced Search

export data from oracle to mysql with sqlplus
Posted by: pooluser ()
Date: November 17, 2005 10:55AM

Hello,

I would like to run a query against a oracle database once a month and per batch. I thought using sqlplus may give me the desired result, but unfortunatelly the output rows are splited into many rows in the text file.

Here is my procedure:
- start sqlplus with following command options: sqlplus username/password@db @H:\sql\oracle.sql

the file oracle.sql contain following statements:
set termout off
set pagesize 0
set linesize 800
set feedback off
spool H:\sql\oracleOutput2mysql.sql

select * from oracleTable;
spool off
exit

My select statements contains 28 Fields, but after 80 characters on the result file the records follow on a second row and so on.

What do I do wrong, I thing "set linesize 800" does not change the behavior of sqlplus. is there another option or tool for this purpose?

Thx for any help.

Cheers
Ahmed

Options: ReplyQuote


Subject Views Written By Posted
export data from oracle to mysql with sqlplus 9867 pooluser 11/17/2005 10:55AM
Re: export data from oracle to mysql with sqlplus 3783 Mohammed Shahryar 03/29/2007 04:40AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.