| SqlLoader Substring in Control File [message #301648] |
Thu, 21 February 2008 04:16  |
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  |
 |
Michel Cadot
Messages: 68728
Registered: March 2007
Location: Saint-Maur, France, https...
|
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
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
