MySQL Forums :: Oracle :: export data from oracle to mysql with sqlplus
export data from oracle to mysql with sqlplus
Date: November 17, 2005 10:55AM
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
select * from oracleTable;
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.
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.