Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
sqlldr question
- Thread starter maswien
- Start date
Yes:
----------------------------------------------------------------------------
The person who says it can't be done should not interrupt the person doing it. -- Chinese proverb
Code:
LOAD DATA
INFILE...
INTO ...
(col1
,col2 DATE 'YYYY-MM-DD'
,...etc...----------------------------------------------------------------------------
The person who says it can't be done should not interrupt the person doing it. -- Chinese proverb
mjia,
Yes, that's right you need a CTL file just like LKBrwnDBA has posted.
Then invoke the sqlldr from an OS shell say in Unix shell.
$$ SQLLDR CONTROL=foo.ctl, LOG=bar.log, BAD=baz.bad, DATA=etc.dat
If you want to know more about SQL Loader you might want to read this < I hope this will help!
Cheers,
joe5902
Yes, that's right you need a CTL file just like LKBrwnDBA has posted.
Then invoke the sqlldr from an OS shell say in Unix shell.
$$ SQLLDR CONTROL=foo.ctl, LOG=bar.log, BAD=baz.bad, DATA=etc.dat
If you want to know more about SQL Loader you might want to read this < I hope this will help!
Cheers,
joe5902
- Status