MySQL Long Text to ORACLE CLOB [message #203988] |
Fri, 17 November 2006 04:06 |
|
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 |
|
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
|
|
|