Problem in loading the data file into a table [message #70522] |
Tue, 25 June 2002 07:18 |
Rohit Seth
Messages: 1 Registered: June 2002
|
Junior Member |
|
|
Hi techies,
I am using SQL Loader to load a data file into a table.
The data file had 75000 records.
But only 14900 got loaded into the table.
Also it wrote some 114 records to the bad file.
The SQL Loader log file gives the following error message:-
Record <record no>: Rejected - Error on table "NORDPLU"."PLU_STAGE".
ORA-00600: internal error code, arguments: [[klapush_20]], [[0]], [[0]], [[]], [[]], [[]], [[]], [[]]
When I renamed the bad file to the data file and again invoked SQL* Loader, it loaded these 114 records successfully into the table.
Also the data is correct because I am able to load the data file into the table using external table.
Then what could be the problem with SQL Loader?
Pl help!
Thanks in adv,
Cheers,
Rohit
|
|
|
|