| Help [message #69369] |
Mon, 17 December 2001 00:23  |
MY HANH
Messages: 2
Registered: December 2001
|
Junior Member |
|
|
Thank you for your answer but I get a new trouble. After invoke Sql*loader , it appears control =....
I don't understand control file, data file ... Could you explain for me?. How to create control file.Please
----------------------------------------------------------------------
|
|
|
|
| Re: Help [message #69371 is a reply to message #69369] |
Mon, 17 December 2001 03:28  |
Suresh Vemulapalli
Messages: 624
Registered: August 2000
|
Senior Member |
|
|
control file is small file which tells sqlloader how to load data,how data look like, where to load, location of data file etc.
sample control file:(you can write control file using any editor e.g notepad in windows, vi in unix)
LOAD DATA
INFILE 'emp1.txt'
APPEND
INTO TABLE emp
(empno position(01:05) ,
ename position(07:15) ,
sal position(17:20))
Data file: name of the file contains data.
in above example emp1.txt is data file.
For more info: refer in sqlloader documentation.
If documentation is not installed on your machine, go to
Oracle documentation
and click on oracle 8i utilities.(registration is free for this site and useful)
Suresh
----------------------------------------------------------------------
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
