UNIX for Dummies Questions & Answers

Hi,
I need to delete one row from a .dat file.
error processing column PCT_USED in row 1053295 for datafile /exp/stats/ts_stats.dat
ORA-01722: invalid number

This is used to load records using sql loader.

Please let me know the procedure to do it.

Regards,
VN

The file extension .dat conventionally means that the file is a binary file and does not meet the requirements to be classified as a text file. If that is true in this case, you'll need to either go back to the program that created the file and fix the data that was used to generate the error on that line or find (or write) a tool that can be used to determine record boundaries in the binary file and remove the offending record. If the records all contain the same number of bytes, the dd utility can be used to delete the bad record. Otherwise, you may need to write a simple (or extremely complex) C program to find the record and remove it. The complexity of the program will depend on the format of records with the binary file.

Hi,

This file is loaded using sql loader.
There is a bad record created and i need to delete this record.

Regards,
VN

We don't know the format of the text file(s) you're feeding into sqlldr or sqlload to load your database. It is up to you to find and delete the line(s) from your input file(s) that will be transformed into the bad record.

We don't have access to your schemas, your SQL*Loader control files, or the files to be loaded so there isn't much we can do to help.