SqlLoader Substring in Control File [message #301648] |
Thu, 21 February 2008 04:16 ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
ginshin
Messages: 5 Registered: February 2008
|
Junior Member |
|
|
Hi,
I have this Control File :
LOAD DATA INFILE "C:\Temp\ChgEvt.DAT"
APPEND
INTO TABLE EVT
FIELDS TERMINATED X'09'
TRAILING NULLCOLS
(F1,F2,F3,F4,F5,F6,F7,F8,F9,EVT_MAJ,EVT_GUILTY,EVT_DDM)
In the shema of my Oracle Database, the field F9 is a varchar2(4000). Sometimes the source file C:\Temp\ChgEvt.DAT contains data >4000 characters in the F9 field !
What is the solution ? Truncate the data ?
|
|
|
|
|
|
|
|
|
|
|
Re: SqlLoader Substring in Control File [message #301722 is a reply to message #301716] |
Thu, 21 February 2008 08:01 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) |
![](http://www.orafaq.com/forum/images/custom_avatars/102589.gif) |
Michel Cadot
Messages: 68678 Registered: March 2007 Location: Nanterre, France, http://...
|
Senior Member Account Moderator |
|
|
You can't directly do alter.
You have to add a CLOB column, move the data to the new column, drop the old column, rename the new one.
Or create a new table as select from the old one, drop the old table and rename the new one.
Or use dbms_redefinition package
Or use export/drop table/recreate table/import
Or...
But you can't directly use alter table.
Regards
Michel
|
|
|