عندي على قاعدة البيانات جدول واريد ان استورد له بيانات خارجية من ملف : txt , او dat
وقمت بعمل الاتي:
1- انشاء ملف : MUNICIPALITY.ctl
LOAD DATA
INFILE 'D:\MUNICIPALITY.dat'
append
INTO TABLE MUNICIPALITY.ESTATE_CODES
FIELDS TERMINATED BY ','
(STATE_ID,CENTER_ID,AREA_ID,ESTATE_ID,ESTATE_NO,UN IT_NO,ESTATE_TYPE,ADDRESS,NOTE
S,ISUSED,CREATED_BY,CREATED_ON,MODIFIED_BY,MODIFIE D_ON)
- انشاء ملف : Municipality.dat
9,5,1,26,4,0,B,'-',NULL,T,8,01-13-2010,NULL,NULL
بعدها نفذت امر: sqlldr USERID=system/sys control=D:\MUNICIPALITY.ctl LOG=D:\MUNICIPALITY.log
وعند الاطلاع على ملف : LOG=D:\MUNICIPALITY.log
SQL*Loader: Release 10.2.0.1.0 - Production on Wed Jan 13 14:34:40 2010
Copyright © 1982, 2005, Oracle. All rights reserved.
Control File: D:\MUNICIPALITY.ctl
Data File: D:\MUNICIPALITY.dat
Bad File: D:\MUNICIPALITY.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 MUNICIPALITY.ESTATE_CODES, loaded from every logical record.
Insert option in effect for this table: APPEND
Column Name Position Len Term Encl Datatype
------------------------------ ---------- ----- ---- ---- ---------------------
STATE_ID FIRST * , CHARACTER
CENTER_ID NEXT * , CHARACTER
AREA_ID NEXT * , CHARACTER
ESTATE_ID NEXT * , CHARACTER
ESTATE_NO NEXT * , CHARACTER
UNIT_NO NEXT * , CHARACTER
ESTATE_TYPE NEXT * , CHARACTER
ADDRESS NEXT * , CHARACTER
NOTES NEXT * , CHARACTER
ISUSED NEXT * , CHARACTER
CREATED_BY NEXT * , CHARACTER
CREATED_ON NEXT * , CHARACTER
MODIFIED_BY NEXT * , CHARACTER
MODIFIED_ON NEXT * , CHARACTER
Record 1: Rejected - Error on table MUNICIPALITY.ESTATE_CODES, column CREATED_ON.
ORA-01843: not a valid month
Table MUNICIPALITY.ESTATE_CODES:
0 Rows successfully loaded.
1 Row 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: 231168 bytes(64 rows)
Read buffer bytes: 1048576
Total logical records skipped: 0
Total logical records read: 1
Total logical records rejected: 1
Total logical records discarded: 0
Run began on Wed Jan 13 14:34:40 2010
Run ended on Wed Jan 13 14:34:40 2010
Elapsed time was: 00:00:00.15
CPU time was: 00:00:00.11
اين هو الخطا والله لان عجزني هذا الامر وجربت بكل الطرق تغير التاريخ وما نفع شي ؟؟؟؟؟؟؟؟؟؟؟؟؟ وشكراً