| Using Oracle/Sql*loader to Transfer data from the textfile having lakhs of records [message #73770] |
Thu, 08 July 2004 23:29  |
Rambabu.N
Messages: 3
Registered: July 2004
|
Junior Member |
|
|
Hi,
I am facing the problem while transfering data from text files into database by using Oracle sql*loader. Please kindly respond asap.
I supposed to Transfer data from text file which is having lakhs of records (tuples) . I tried the following comamnd at sql prompt
SQL> sqlldr userid=scott/tiger control='c:emp.ctl' data='c:emp.txt'
emp.ctl having the following code :
Load Data
infile *
append
into table emp fields terminated by ',' optionally enclosed by ' " '
(empno,ename,deptno,mgr)
and emp.txt contains bulk of tuples (nearly 1 lakh records).
I tried the above command , its working. but is is transfering only less than 100 records.
But i wanted to transfer all the records(1 lakh) at a time.
Please answer the above and help me .
Thanking you.
Regards,
Rams.
|
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
