MySQL Forums
Forum List  »  Oracle

Re: Importing from Oracle into MySQL
Posted by: taka_98
Date: March 30, 2005 06:13PM

check the post below, it has some suggestions:

http://forums.mysql.com/read.php?61,4260,6109#msg-6109

David Beckedorff wrote:
> Hi Folks,
>
> I'm trying to move data from an Oracle 9i schema
> to a MySQL 4.1 instance. First, I tried the new
> migration tool, but the wizard blew up connecting
> to the two databases. Oh well, not yet ready for
> prime time.
>
> So now I'm using SQL*Plus in batch mode on the
> Oracle side to generate insert statements from
> tables of interest, outputting to SQL script
> files. That works fine.
>
> Next I try to import the SQL scripts containing
> the insert statements using the 'mysql' command
> line tool. But 'mysql' bombs reading the input
> lines at the 81st character. It's like it's a
> 1970's style teletype interface.
>
> >>>
> mysql> source insert_into_managerlog.sql
> ERROR 1064 (42000): You have an error in your SQL
> syntax; check the manual that corresponds
> to your MySQL server version for the right syntax
> to use near 'insert into managerlog values
> (null,'2005-02-11
> 14:37:40','fvmweb.cellexchange.co' at line 2
> mysql>
> <<<
>
> The line I'm trying to insert is:
> >>>
> insert into managerlog values(null,'2005-02-11
> 14:37:40','fvmweb.cellexchange.com','OC4J_fvm',381
> 6,'FVM-JVM-1','LOGON','2005-02-11
> 14:37:40','','3f7c5709ce614195caa5b094ff9912dfb80d
> 2a6c522','000512','AEROGRAPHERS MATE')
> <<<
>
> Does anyone know how to increase the 'mysql'
> tool's input line buffer size from 80 characters
> to something reasonable like say 512 or 1,024.
>
> Another question. Is it possible to get rid of
> this part of the error message:
>
> >>>
> check the manual that corresponds
> to your MySQL server version for the right syntax
> to use
> <<<
>
> The verbosity level is too high. Also, how do we
> turn off the alarm bell associated with 'mysql's
> error messages?
>
> Thanks,

Options: ReplyQuote


Subject
Views
Written By
Posted
3982
January 22, 2007 12:48AM
Re: Importing from Oracle into MySQL
4609
March 30, 2005 06:13PM


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.