Home » RDBMS Server » Server Utilities » Problem in loading the data file into a table
Problem in loading the data file into a table [message #70522] Tue, 25 June 2002 07:18 Go to next message
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
Re: Problem in loading the data file into a table [message #70524 is a reply to message #70522] Tue, 25 June 2002 08:11 Go to previous message
Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
try
the sqlldr again with Direct=N
and please let me know the results
Previous Topic: need to maintain consistency of data
Next Topic: Regarding the backup
Goto Forum:
  


Current Time: Tue May 07 20:29:17 CDT 2024