load data

[faathir88]

can anybody help me...
i have a lot of data (more than 50000 rows)... and i want to load it into my database... but when i try to load it, i just get a few data.... how can i load all of my data into my database??

[r035198x]

How are you loading the data?

[faathir88]

How are you loading the data?

i load them by using sql loader. i got the control file which specify the location of the data file.

the command:

sqlldr userid=id/pass
control : c:\authors_csv. dat

it succeded, but the problem is that it only loaded a few of them (140 from 90000). i wonder whether i skip some parameter on it.

[amitpatel66]

i load them by using sql loader. i got the control file which specify the location of the data file.

the command:

sqlldr userid=id/pass
control : c:\authors_csv. dat

it succeded, but the problem is that it only loaded a few of them (140 from 90000). i wonder whether i skip some parameter on it.

I am sure most of the records are getting rejected either due to improper format or some other reason. Use this command and check the bad,discard file:

[code=oracle]

SQLLDR userid=user/password control='D:/control.ctl' data='D:/data.dat' bad='D:/bad_data.bad' discard='D:/disc_data.dsc'

[/code]

[faathir88]

it doesn't work...
.bad file just contain 50 data...
and even .dsc file not contain any data

[amitpatel66]

it doesn't work...
.bad file just contain 50 data...
and even .dsc file not contain any data

It is working. The SQLLDR runs for some records and when the record count in BAD file reaches 50 then it stops uploading expecting you to fix the and rerun.

DSC file is empty because NONE of the records are discarded at that point of time.

Hint's to solve this bad records:

1. Check for the date format in the data file if any date column is there. And use the same format in the Control file as well
2. If you are using positions for each column value, then check they are proper.