Home » Open Source » MySQL » MySQL Long Text to ORACLE CLOB
icon11.gif  MySQL Long Text to ORACLE CLOB [message #203988] Fri, 17 November 2006 04:06 Go to next message
amit_nanote
Messages: 56
Registered: July 2005
Location: Indore
Member

Hi All,

I am dumping MySQL table to Oracle. This MySQL Table is having a column of type Long text which maps in oracle to CLOB.
Migration goes successful but the length of data in oracle (Destination table) is only 81 characters while in the MySQl (Source Table) it has more then 5000 characters in few rows.

What is the reason behind this behavior? Any body who knows please explain.

With regards
Amit Nanote
Re: MySQL Long Text to ORACLE CLOB [message #204619 is a reply to message #203988] Tue, 21 November 2006 07:02 Go to previous message
amit_nanote
Messages: 56
Registered: July 2005
Location: Indore
Member

Hi All,

Got the problem solved.. set the evnironment variable to 10000. ex set long 1000
Now the problem is its not taking more then 2499 characters as input. Gives the error. The row which I supposed is having more then 5000 character had only 240 characters.

I get the problem during insert of more then 2499 character in the CLOB that
Value(>2499) is too long.
Is there any kind of parameter which we can use to change this setting or any other way to insert it into the database.

with regards
Amit Nanote
Previous Topic: Migration MySQL to Oracle
Next Topic: Migrate MySQL Table to Oracle Materialized View
Goto Forum:
  


Current Time: Sat Dec 14 14:08:31 CST 2024