Hi
Maybe I am missing something. Why not install MySQL on a windows box
and use one of those porters. Then just copy your tables to the Linux box.
Mike
----- Original Message -----
From: "J. Allen Crider" <[EMAIL PROTECTED]>
To: "Rhino" <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: February 19, 2004 3:37 AM
Subject: Re: oracledump.pl error
> Obviously I wrote my original message too quickly and did not make
> myself clear. I am well aware that DB2 and numerous other commercial
> products work on Linux. What I meant to say was that, of all of the
> products that I could find listed on www.mysql.com for converting data
> from Oracle to MySQL, all of the commercial products except SQLPorter
> are written specifically for MS Windows and do not have Linux versions.
> That leaves the most obvious options for converting the data in my
> Oracle database to MySQL being oracledump.pl or rolling my own
> solution. If there are other tools that will do the job easily, either
> open source or low-cost commercial, I would like to hear about them.
>
> Rhino wrote:
>
> >I don't have any insight into your problem but I want to take exception
with
> >your assertion that no other commercial products work on Linux. In fact,
DB2
> >works on Linux and has for some time. Here's a link to information about
> >this product: http://www-306.ibm.com/software/data/db2/udb/
> >
> >If you nose around the IBM site a bit, you should be able to find a free
> >full-function copy of DB2 for Linux. (By free, I mean you don't need a
> >licence for it unless you use it in production. This enables you to get
very
> >acquainted with DB2 for free and only buy a licence if you like it enough
to
> >use it in production.)
> >
> >Rhino
> >
> >
> >
> >----- Original Message -----
> >From: "J. Allen Crider" <[EMAIL PROTECTED]>
> >To: <[EMAIL PROTECTED]>
> >Sent: Wednesday, February 18, 2004 10:54 PM
> >Subject: oracledump.pl error
> >
> >
> >
> >
> >>I have just decided to try to learn something about MySQL after several
> >>years of working with Oracle and wanted to transfer the data I have in
> >>an Oracle 9i database to a new MySQL database. Since this is strictly
> >>for personal use, I can't justify the cost of SQLPorter, and none of the
> >>other commercial products work on Linux, so I decided to try
> >>oracledump.pl. However, I am getting the following error when I attempt
> >>to run it:
> >>
> >>DBD::Oracle::st execute failed: ORA-01459: invalid length for variable
> >>character string (DBD ERROR: OCIStmtExecute) [for statement ``SELECT
> >>a.COLUMN_ID,
> >> a.COLUMN_NAME,
> >> a.DATA_TYPE,
> >> a.DATA_LENGTH,
> >> a.DATA_PRECISION,
> >> a.DATA_SCALE,
> >> a.NULLABLE,
> >> a.DATA_DEFAULT,
> >> b.COMMENTS
> >> FROM USER_TAB_COLUMNS a, USER_COL_COMMENTS b
> >> WHERE a.TABLE_NAME = ? AND b.TABLE_NAME =
> >>a.TABLE_NAME AND b.COLUMN_NAME = a.COLUMN_NAME'' with params:
> >>:p1='ALBUMS']) at ./oracledump.pl line 471.
> >>
> >>(followed by several other errors obviously caused by this error.)
> >>
> >>Running the same statement in sqlplus works fine.
> >>
> >>I am running Oracle 9i Release 2 on Gentoo Linux. Any ideas on what I'm
> >>doing wrong?
> >>
> >>Allen Crider
> >>Huntsville, AL
> >>[EMAIL PROTECTED]
> >>
> >>
> >>--
> >>MySQL General Mailing List
> >>For list archives: http://lists.mysql.com/mysql
> >>To unsubscribe:
http://lists.mysql.com/[EMAIL PROTECTED]
> >>
> >>
> >>
> >
> >
> >
> >
>
>
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:
http://lists.mysql.com/[EMAIL PROTECTED]
>
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
