I am trying to migrate data from one table to other using sql loader.One of the columns having too long data is getting cut in the middle and is not flowing ibto the table.There are no data errors.The column size is varchar(400).Do I have to set some option for sql loader??
u can do it utilising replace command, all rows interior the column would be assigned to null at atime. that's the table i had on the beginning up: sq. choose * from cmsws_users; USERNAME PASSWORD form ------------------------- ------------------------- -------------------- mythri mythri dmexp meetu meetu mmgr anm anm dme the outline of the table: sq. desc cmsws_users; call Null? form ----------------------------------------... -------- ---------------- USERNAME VARCHAR2(25) PASSWORD VARCHAR2(25) form VARCHAR2(20) make beneficial that the column which u needed to change would desire to enable null values. now the question to change is : sq. replace cmsws_users SET form = NULL; 3 rows as much as date. the table after utilising replace question is: sq. choose * from cmsws_users; USERNAME PASSWORD form ------------------------- ------------------------- --------------- mythri mythri meetu meetu anm anm verify this out the preparation interior the shape column is deleted with out deleting the column itself.
Is the break occurring at the same spot for every record with a field = a particular value? Is so, sounds like somehow SQL Loader is misinterpreting the definition somehow. If not, sounds more like a problem with the data itself (contains a character interpreted as a delimiter or some such.)
Oracle has a limit of 4,000 bytes (thats bytes not characters!) per column. your 400 charcters should be well within that limit and SQL Loader should be able to load such data correctly. so why does the truncation occur? does the source table have the same definition as the target or are the fields different?
