الاخوة والاخوات الاعزاء


قمت بتحويل بيانات جدول من اكسس الى اوراكل بطريقة sqlldr .... حيث تم اعطاءطول البيانات في الاكسس عند تصميم المشروع الى 255 char

وعند التحويل تم تحويل فقط اول عموديين ولم يتم تحويل بقية الاعمدة ... وظهرت لي الرسالة التالية


SQL*Loader: Release 9.0.1.1.1 - Production on Thu Feb 21 05:10:12 2008

© Copyright 2001 Oracle Corporation. All rights reserved.

Control File: a.ctl
Data File: a.txt
Bad File: a.bad
Discard File: none specified

(Allow all discards)

Number to load: ALL
Number to skip: 0
Errors allowed: 50
Bind array: 64 rows, maximum of 256000 bytes
Continuation: none specified
Path used: Conventional

Table AHMED, loaded from every logical record.
Insert option in effect for this table: INSERT

Column Name Position Len Term Encl Datatype
------------------------------ ---------- ----- ---- ---- ---------------------
A1 1:5 5 CHARACTER
A2 6:100 95 CHARACTER
A3 101:115 15 CHARACTER
A4 116:130 15 CHARACTER
A5 131:160 30 CHARACTER
A6 161:190 30 CHARACTER
A7 191:210 20 CHARACTER
A8 211:240 30 CHARACTER
A9 241:260 20 CHARACTER
A10 261:270 10 CHARACTER
A11 271:330 60 CHARACTER
A12 331:331 1 CHARACTER

Record 1629: Rejected - Error on table AHMED.
ORA-01401: inserted value too large for column

Record 1630: Rejected - Error on table AHMED.
ORA-01401: inserted value too large for column

Record 1663: Rejected - Error on table AHMED.
ORA-01401: inserted value too large for column

Record 1668: Rejected - Error on table AHMED.
ORA-01401: inserted value too large for column

Record 1730: Rejected - Error on table AHMED.
ORA-01401: inserted value too large for column

Record 1731: Rejected - Error on table AHMED.
ORA-01401: inserted value too large for column

Record 1732: Rejected - Error on table AHMED.
ORA-01401: inserted value too large for column

Record 1733: Rejected - Error on table AHMED.
ORA-01401: inserted value too large for column

Record 1734: Rejected - Error on table AHMED.
ORA-01401: inserted value too large for column

Record 1735: Rejected - Error on table AHMED.
ORA-01401: inserted value too large for column

Record 1736: Rejected - Error on table AHMED.
ORA-01401: inserted value too large for column

Record 1737: Rejected - Error on table AHMED.
ORA-01401: inserted value too large for column

Record 1738: Rejected - Error on table AHMED.
ORA-01401: inserted value too large for column

Record 1739: Rejected - Error on table AHMED.
ORA-01401: inserted value too large for column

Record 1740: Rejected - Error on table AHMED.
ORA-01401: inserted value too large for column

Record 1741: Rejected - Error on table AHMED.
ORA-01401: inserted value too large for column

Record 1742: Rejected - Error on table AHMED.
ORA-01401: inserted value too large for column

Record 2458: Rejected - Error on table AHMED.
ORA-01401: inserted value too large for column

Record 2459: Rejected - Error on table AHMED.
ORA-01401: inserted value too large for column

Record 2460: Rejected - Error on table AHMED.
ORA-01401: inserted value too large for column

Record 2461: Rejected - Error on table AHMED.
ORA-01401: inserted value too large for column

Record 2462: Rejected - Error on table AHMED.
ORA-01401: inserted value too large for column

Record 2467: Rejected - Error on table AHMED.
ORA-01401: inserted value too large for column

Record 2469: Rejected - Error on table AHMED.
ORA-01401: inserted value too large for column

Record 2470: Rejected - Error on table AHMED.
ORA-01401: inserted value too large for column

Record 2472: Rejected - Error on table AHMED.
ORA-01401: inserted value too large for column

Record 2474: Rejected - Error on table AHMED.
ORA-01401: inserted value too large for column

Record 2475: Rejected - Error on table AHMED.
ORA-01401: inserted value too large for column

Record 2482: Rejected - Error on table AHMED.
ORA-01401: inserted value too large for column

Record 2484: Rejected - Error on table AHMED.
ORA-01401: inserted value too large for column

Record 2485: Rejected - Error on table AHMED.
ORA-01401: inserted value too large for column

Record 2486: Rejected - Error on table AHMED.
ORA-01401: inserted value too large for column

Record 2487: Rejected - Error on table AHMED.
ORA-01401: inserted value too large for column

Record 2488: Rejected - Error on table AHMED.
ORA-01401: inserted value too large for column

Record 2489: Rejected - Error on table AHMED.
ORA-01401: inserted value too large for column

Record 2491: Rejected - Error on table AHMED.
ORA-01401: inserted value too large for column

Record 2492: Rejected - Error on table AHMED.
ORA-01401: inserted value too large for column

Record 2493: Rejected - Error on table AHMED.
ORA-01401: inserted value too large for column

Record 2494: Rejected - Error on table AHMED.
ORA-01401: inserted value too large for column

Record 2496: Rejected - Error on table AHMED.
ORA-01401: inserted value too large for column

Record 2497: Rejected - Error on table AHMED.
ORA-01401: inserted value too large for column

Record 2498: Rejected - Error on table AHMED.
ORA-01401: inserted value too large for column

Record 2499: Rejected - Error on table AHMED.
ORA-01401: inserted value too large for column

Record 2500: Rejected - Error on table AHMED.
ORA-01401: inserted value too large for column

Record 2501: Rejected - Error on table AHMED.
ORA-01401: inserted value too large for column

Record 2502: Rejected - Error on table AHMED.
ORA-01401: inserted value too large for column

Record 2531: Rejected - Error on table AHMED.
ORA-01401: inserted value too large for column

Record 2533: Rejected - Error on table AHMED.
ORA-01401: inserted value too large for column

Record 2536: Rejected - Error on table AHMED.
ORA-01401: inserted value too large for column

Record 2537: Rejected - Error on table AHMED.
ORA-01401: inserted value too large for column

Record 2538: Rejected - Error on table AHMED.
ORA-01401: inserted value too large for column


MAXIMUM ERROR COUNT EXCEEDED - Above statistics reflect partial run.

Table AHMED:
2487 Rows successfully loaded.
51 Rows not loaded due to data errors.
0 Rows not loaded because all WHEN clauses were failed.
0 Rows not loaded because all fields were null.


Space allocated for bind array: 23040 bytes(64 rows)
Read buffer bytes: 1048576

Total logical records skipped: 0
Total logical records read: 2587
Total logical records rejected: 51
Total logical records discarded: 0

Run began on Thu Feb 21 05:10:12 2008
Run ended on Thu Feb 21 05:10:13 2008

Elapsed time was: 00:00:00.45
CPU time was: 00:00:00.06


ما هو الخطا ؟؟؟ وهل من طريقة يتم بها التحويل من خلال برنامج تود او اي برنامج اخر

ORA-01401: inserted value too large for column
Cause: The value entered is larger than the maximum width defined for the column.
Action: Enter a value smaller than the column width or use the MODIFY option with ALTER TABLE to expand the column width.

يوجد بيانات لاحد الاعمدة طولها اكثر مما هو معرف فى مواصفات الجدول


اليك موقع شرح الخطأ وطريقة الحل