Hi All,
I am having an problem with sqlldr, i need to load a large file. I have a control file, when I start the loader, it 1/2 loads the first record.
I have added below the ctl file, bad file and first record.
tim
++++++++++++++++++++++++++
++++1
Control File:
load data
infile 'c:\XXX\23_2.txt'
append into table tim.D_DATA
(Client CHAR Terminated by "," enclosed by '"' ,
Backup_id CHAR Terminated by "," enclosed by '"' ,
Policy_type CHAR Terminated by "," enclosed by '"' ,
Proxy_client CHAR Terminated by "," enclosed by '"' ,
Creator CHAR Terminated by "," enclosed by '"' ,
Name_1 CHAR Terminated by "," enclosed by '"' ,
Sched_label CHAR Terminated by "," enclosed by '"' ,
Schedule_Type CHAR Terminated by "," enclosed by '"' ,
Retention_Level CHAR Terminated by "," enclosed by '"' ,
Backup_Time CHAR Terminated by "," enclosed by '"' ,
Elapsed_Time CHAR Terminated by "," enclosed by '"' ,
Expiration_Time CHAR Terminated by "," enclosed by '"' ,
Compressed CHAR Terminated by "," enclosed by '"' ,
Encrypted CHAR Terminated by "," enclosed by '"' ,
Kilobytes INTEGER EXTERNAL Terminated by "," enclosed by '"' ,
Number_of_Files INTEGER EXTERNAL Terminated by "," enclosed by '"' ,
Number_of_Copies INTEGER EXTERNAL Terminated by "," enclosed by '"' ,
Number_of_Fragments INTEGER EXTERNAL Terminated by "," enclosed by '"' ,
Histogram CHAR Terminated by "," enclosed by '"' ,
DB_Compressed CHAR Terminated by "," enclosed by '"' ,
Files_File_Name CHAR Terminated by "," enclosed by '"' ,
Previous_Backup_Files_File
_Nam CHAR Terminated by "," enclosed by '"' ,
SW_Version CHAR Terminated by "," enclosed by '"' ,
Options CHAR Terminated by "," enclosed by '"' ,
MPX INTEGER EXTERNAL Terminated by "," enclosed by '"' ,
TIR_Info CHAR Terminated by "," enclosed by '"' ,
TIR_Expiration CHAR Terminated by "," enclosed by '"' ,
Keyword CHAR Terminated by "," enclosed by '"' ,
Ext_Security CHAR Terminated by "," enclosed by '"' ,
File_Restore_Raw CHAR Terminated by "," enclosed by '"' ,
Image_Dump_Level CHAR Terminated by "," enclosed by '"' ,
File_System_Only CHAR Terminated by "," enclosed by '"' ,
Object_Descriptor CHAR Terminated by "," enclosed by '"' ,
Previous_BI_Time CHAR Terminated by "," enclosed by '"' ,
BI_Full_Time CHAR Terminated by "," enclosed by '"' ,
Request_Pid CHAR Terminated by "," enclosed by '"' ,
Backup_Status CHAR Terminated by "," enclosed by '"' ,
Stream_Number CHAR Terminated by "," enclosed by '"' ,
Backup_Copy CHAR Terminated by "," enclosed by '"' ,
Files_File_size INTEGER EXTERNAL Terminated by "," enclosed by '"' ,
PFI_type CHAR Terminated by "," enclosed by '"' ,
IMAGE_ATTRIBUTE CHAR Terminated by "," enclosed by '"' ,
Primary_Copy CHAR Terminated by "," enclosed by '"' ,
Image_Type CHAR Terminated by "," enclosed by '"' ,
Job_ID INTEGER EXTERNAL Terminated by "," enclosed by '"' ,
Num_Resumes CHAR Terminated by "," enclosed by '"' ,
Resume_Expiration CHAR Terminated by "," enclosed by '"' ,
Copy_number_3 INTEGER EXTERNAL Terminated by "," enclosed by '"' ,
Fragment_3 INTEGER EXTERNAL Terminated by "," enclosed by '"' ,
Kilobytes_3 INTEGER EXTERNAL Terminated by "," enclosed by '"' ,
Remainder CHAR Terminated by "," enclosed by '"' ,
Media_Type CHAR Terminated by "," enclosed by '"' ,
Density CHAR Terminated by "," enclosed by '"' ,
File_Num INTEGER EXTERNAL Terminated by "," enclosed by '"' ,
ID_1 CHAR Terminated by "," enclosed by '"' ,
Host_1 CHAR Terminated by "," enclosed by '"' ,
Block_Size_1 CHAR Terminated by "," enclosed by '"' ,
Offset_1 CHAR Terminated by "," enclosed by '"' ,
Dev_Written_1 CHAR Terminated by "," enclosed by '"' ,
Flags_1 CHAR Terminated by "," enclosed by '"' ,
Media_Descriptor_1 CHAR Terminated by "," enclosed by '"' ,
checkpoint_1 CHAR Terminated by "," enclosed by '"' ,
resume_num_1 CHAR Terminated by "," enclosed by '"' ,
Copy_number_1 CHAR Terminated by "," enclosed by '"' ,
Fragment_1 INTEGER EXTERNAL Terminated by "," enclosed by '"' ,
Kilobytes_1 INTEGER EXTERNAL Terminated by "," enclosed by '"' ,
Remainder_1 CHAR Terminated by "," enclosed by '"' ,
Media_Type_1 CHAR Terminated by "," enclosed by '"' ,
Density_1 CHAR Terminated by "," enclosed by '"' ,
File_Num_1 CHAR Terminated by "," enclosed by '"' ,
ID_2 CHAR Terminated by "," enclosed by '"' ,
Host_2 CHAR Terminated by "," enclosed by '"' ,
Block_Size_2 INTEGER EXTERNAL Terminated by "," enclosed by '"' ,
Offset_2 CHAR Terminated by "," enclosed by '"' ,
Media_Date_2 CHAR Terminated by "," enclosed by '"' ,
Dev_Written_2 CHAR Terminated by "," enclosed by '"' ,
Flags_2 CHAR Terminated by "," enclosed by '"' ,
Media_Descriptor_2 CHAR Terminated by "," enclosed by '"' ,
Expiration_Time_2 CHAR Terminated by "," enclosed by '"' ,
MPX_2 CHAR Terminated by "," enclosed by '"' ,
retention_lvl_2 CHAR Terminated by "," enclosed by '"' ,
checkpoint_2 CHAR Terminated by "," enclosed by '"' ,
resume_num_2 CHAR Terminated by "," enclosed by '"' ,
END_OF_RECORD CHAR Terminated by ","
)
++++++++++++++++++++++++++
++++++++++
+++++++
One source records
"XXX.XXX.net",
"XXX.XXX.net_1184032683",
"Filesystem_EB_Windows",
"MS-Windows-NT (13)",
"(none specified)",
"root",
"(none specified)",
"Daily",
"CINC (4)",
"8 days (10)",
"Tue Jul 10 2007 02:58:03 (1184032683)",
"279 second(s)",
"Wed Jul 18 2007 02:58:03 (1184723883)",
"no",
"no",
"362361",
"3773",
"1",
"2",
"-1 -1 -1 -1 -1 -1 -1 -1 -1 -1",
"no",
"Filesystem_EB_Windows_118
4032683_IN
CR.f",
"Filesystem_EB_Windows_118
3780228_FU
LL.f",
"(none specified)",
"0x0",
"0",
"4",
"Wed Jul 11 2007 02:58:03 (1184119083)",
"(none specified)",
"no",
"no",
"0",
"no",
"(none specified)",
"Thu Jan 01 1970 01:00:00 (0)",
"Thu Jan 01 1970 01:00:00 (0)",
"0",
"0",
"0",
"Standard (0)",
"2695915",
"0",
"0",
"1",
"0 (Regular)",
"1969145",
"0",
"Thu Jan 01 1970 01:00:00 (0)",
"1",
"TIR (-1)",
"2633",
"0",
"Media Manager (2)",
"hcart2 (14)",
"344",
"MP0430",
"XXX.XXX.net",
"65536",
"6635630",
"Sun Jul 08 2007 20:07:52 (1183921672)",
"0",
"0x0",
"?",
"0",
"0",
"1",
"1",
"359728",
"0",
"Media Manager (2)",
"hcart2 (14)",
"343",
"MP0430",
"cscsvsmds005i02.msd.nwwml
sp.net",
"65536",
"6630007",
"Sun Jul 08 2007 20:07:52 (1183921672)",
"0",
"0x0",
"?",
"Wed Jul 18 2007 02:58:03 (1184723883)",
"0",
"8 days (10)",
"0",
"0",
"Hello;
++++++++++++++++++++++++++
++++++++++
++++1
Bad file:
"XXX.XXX.net",
"XXX.XXX.net_1184032683",
"Filesystem_EB_Windows",
"MS-Windows-NT (13)",
"(none specified)",
"root",
"(none specified)",
"Daily",
"CINC (4)",
"8 days (10)",
"Tue Jul 10 2007 02:58:03 (1184032683)",
"279 second(s)",
"Wed Jul 18 2007 02:58:03 (1184723883)",
"no",
"no",
"362361",
"3773",
"1",
"2",
"-1 -1 -1 -1 -1 -1 -1 -1 -1 -1",
"no",
"Filesystem_EB_Windows_118
4032683_IN
CR.f",
"Filesystem_EB_Windows_118
3780228_FU
LL.f",
"(none specified)",
"0x0",
"0",
"4",
"Wed Jul 11 2007 02:58:03 (1184119083)",
"(none specified)",
"no",
"no",
"0",
"no",
"(none specified)",
"Thu Jan 01 1970 01:00:00 (0)",
"Thu Jan 01 1970 01:00:00 (0)",
"0",
"0",
"0",
"Standard (0)",
"2695915",
"0",
"0",
"1",
"0 (Regular)",
"1969145",
"0",
"Thu Jan 01 1970 01:00:00 (0)",
"1",
"TIR (-1)",
"2633",
