MySQL Forums
Forum List  »  Oracle

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
11439
November 17, 2005 10:55AM


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.