sqlldr

Hi

I was trying to insert in a tables using sqlldr. i want to insert into three tables using one control file and give 'infile *' and begindata all in one file .

The script looked like this .

LOAD DATA
 INFILE *
 APPEND INTO TABLE TEST
FIELDS TERMINATED BY "," OPTIONALLY ENCLOSED BY '"' TRAILING NULLCOLS (
KL)
BEGINDATA
"jump",
"jump",
"jump",
"jump",
"jump",
"jump",
"jump",
"jump",
"jump",
"jump",
"jump",
"jump",
"jump",
"jump",
"jump",
"jump",
"jump",
"jump",
"jump",
"jump",

--begining of second table
LOAD DATA
 INFILE *
 APPEND INTO TABLE TEST2
FIELDS TERMINATED BY "," OPTIONALLY ENCLOSED BY '"' TRAILING NULLCOLS (
TABLE_NAME,
TABLE_TYPE)
BEGINDATA
"TEST","TABLE",
"TEST2","TABLE"

--begining of third table
LOAD DATA
 INFILE *
 APPEND INTO TABLE TEST3
FIELDS TERMINATED BY "," OPTIONALLY ENCLOSED BY '"' TRAILING NULLCOLS (
OBJECT_NAME,
SUBOBJECT_NAME,
OBJECT_ID,
DATA_OBJECT_ID,
OBJECT_TYPE,
CREATED DATE 'YYYY/MM/DD HH24:MI:SS' NULLIF CREATED=BLANKS, LAST_DDL_TIME DATE 'YYYY/MM/DD HH24:MI:SS' NULLIF LAST_DDL_TIME=BLANKS,
TIMESTAMP,
STATUS,
TEMPORARY,
GENERATED,
SECONDARY)
BEGINDATA
"TEST","",2746,2746,"TABLE",2000/07/14 11:27:03,2000/07/14

11:27:03,"2000-07-14:11:27:03","VALID","N","N","N",


"TEST2","",2747,2747,"TABLE",2000/07/17 11:10:14,2000/07/17

11:10:14,"2000-07-17:11:10:14","VALID","N","N","N",

What happens is, it loads the whole data in first table. and nothing goes in second and third table. what i would like to know is there any way to do the same and what is complementary to begindata ( i mean something like enddata for sqlldr to know that the ends here and start for next table ).

Thanks Received on Mon Jul 16 2001 - 02:30:44 CDT