Hi everybody !
This is my first post on the forum, and I don't speak english very very well so please be cool with me.
I actually encounter an annoying problem ! Let's explain the situation
I have, in the compay in which I work, 3 different DBMS. SQL Server, Access and Oracle. The company is planning to migrate from Access to Oracle, and I'm in charge of that job. So I'm working on the migration of an Access Database, and I encounter a problem !
I have on the Oracle side the structure; but not the data. And I need to move the data on Access to Oracle. I'm doing this by hand with some CSV exportation, and SQL Loader importation. But there is still a table that makes a problem. In fact, on the Oracle side, that table has a CLOB column, to store large amount of text data. And on Access it's stored in text (I just totally don't know Access xD)
The fact is that when I'm trying to move data from a CSV file exported on Access, to Oracle, I get this error message :
"Record 1: Rejected - Error on table XXX.XXX, column XXX.
Field in data file exceeds maximum length"
Do someone could help me to resolve this problem? I spent hours trying to find something on the internet but without success. :/
Thanks in advance !!
Cordially,
J.Limousin