Hi ,
I'm trying to load data to ORACLE through the load option.
I have about 6 columns to load but the table has other additional columns and one of it is a LONG datatype.
The job aborts saying the COL1 datatype not supported.
How can i avoid this as i'm not interested in loading that LONG datatype.
ORACLE Load -unsupportive type for column not mentioned
Moderators: chulett, rschirm, roy
Seems to me you'll need to avoid any bulk loading options as they typically want all columns to be handled. For Oracle, that specifically means a DIRECT=TRUE 'direct path' load. You should be able to switch to a conventional load which essentially does 'normal' insert/update DML, or just go for plain old insert/update which can easily handle selective column loading.
Now, that LONG may still throw us a curve as they put alot of restrictions of what you can and cannot do to those records but I guess we'll see. BTW, the advice is always to not use them any longer, and to convert existing usage to CLOBs.
Now, that LONG may still throw us a curve as they put alot of restrictions of what you can and cannot do to those records but I guess we'll see. BTW, the advice is always to not use them any longer, and to convert existing usage to CLOBs.
-craig
"You can never have too many knives" -- Logan Nine Fingers
"You can never have too many knives" -- Logan Nine Fingers