473,321 Members | 1,667 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,321 software developers and data experts.

load data

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??
Jul 21 '08 #1
5 1728
r035198x
13,262 8TB
How are you loading the data?
Jul 21 '08 #2
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.
Jul 21 '08 #3
amitpatel66
2,367 Expert 2GB
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:

Expand|Select|Wrap|Line Numbers
  1.  
  2. SQLLDR userid=user/password control='D:/control.ctl' data='D:/data.dat' bad='D:/bad_data.bad' discard='D:/disc_data.dsc'
  3.  
  4.  
Jul 21 '08 #4
it doesn't work...
.bad file just contain 50 data...
and even .dsc file not contain any data
Jul 21 '08 #5
amitpatel66
2,367 Expert 2GB
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.
Jul 21 '08 #6

Sign in to post your reply or Sign up for a free account.

Similar topics

0
by: Donald Tyler | last post by:
Then the only way you can do it that I can think of is to write a PHP script to do basically what PHPMyAdmin is trying to do but without the LOCAL in there. However to do that you would need to...
6
by: Shabam | last post by:
A web application of mine developed using C# + MS SQL runs fine normally. However when I stress test it with a load testing software (using about 60 simultaneous users) some instances start...
1
by: Ray in HK | last post by:
What are the differences between LOAD DATA INFILE and LOAD DATA LOCAL INFILE ? I found some web hosting company do not allow using LOAD DATA INFILE but allow LOAD DATA LOCAL INFILE. The reason...
6
by: JS | last post by:
EE instance DB2 v7.2.0 fixpack 3 on WIN2K. I select some data from a table A and write it to a file using the COALESCE function and whitespace as the null character: eg coalesce(col1, ' '). This...
1
by: Uthuras | last post by:
Greetings, Machine : Pentium IV Os Windows 2000 server Product : DB2 UDB Release : 7.2 We are fail to load the following data file format into db2 database table that has long varchar...
3
by: nsh | last post by:
mailing.database.mysql, comp.lang.php subject: does "LOAD DATA" EVER work?!? I've tried EVERYTHING! version info: my isp is running my web page on a linux box with php ver. 4.4.1 according to...
1
by: huyuhui | last post by:
The following is a question of LOAD utility. Question: How does the DB2 enforce table check constraints for data added to table with the LOAD utility? A. With the BUILD phase of LOAD B. With the...
9
by: RvGrah | last post by:
I'm completely new to using background threading, though I have downloaded and run through several samples and understood how they worked. My question is: I have an app whose primary form...
3
by: GauravGupta | last post by:
i want to know that is it posible to call button click event before page load event on post back.... please help me....
13
by: rdudejr | last post by:
Hi all, I hardly ever make a post unless I am having a very purplexing issue, so this one should be good... I am trying to do a load against a database on an AIX server into a DB2 v9.1...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
1
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
1
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome former...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.