| Import SQL Loader [message #228895] |
Wed, 04 April 2007 08:39  |
jra_kumar
Messages: 7
Registered: April 2007
Location: India
|
Junior Member |
|
|
I want to use the sql loader to import the csv file into oracle fixed table. The problem is how to pass the parameter to the "INLINE" for the sql loader. I'm using windows as my OS and use the toad for the Oracle 9i version. The filename will be different for each day like file010107, file010207,...etc
Please tell me, how to call the control file with the parameter {which is the file name}
|
|
|
|
|
|
|
|
| Re: Import SQL Loader [message #228922 is a reply to message #228916] |
Wed, 04 April 2007 09:28  |
 |
Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille
|
Senior Member
Account Moderator |
|
|
use
in your controlfile
oracle@mutation#cat test.ctl
load data
INFILE *
truncate
INTO TABLE T1
(
n
)
oracle@mutation#cat t1.data
1
2
3
4
5
oracle@mutation#sqlldr userid=scott/tiger control=test.ctl data=t1.data
SQL*Loader: Release 9.2.0.8.0 - Production on Wed Apr 4 10:29:19 2007
Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.
Commit point reached - logical record count 5
oracle@mutation#query mutation scott.t1
N
----------
1
2
3
4
5
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
