Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- C:Usersleesqlloadertest> sqlldr scott/tiger@MYDB,CONTROL='Ad.ctl'
- SQL*Loader: Release 10.2.0.3.0 - Production on Tue Sep 11 17:46:43 2012
- Copyright (c) 1982, 2005, Oracle. All rights reserved.
- Commit point reached - logical record count 52
- C:Usersleesqlloadertest> sqlldr scott/tiger@MYDB CONTROL='Ad.ctl' log=ad.log bad=ad.bad
- LOAD DATA
- INFILE 'Masterpiece.csv' BADFILE 'Masterpiece.bad' DISCARDFILE 'Masterpiece.dis'
- APPEND
- INTO TABLE ADDRESS
- fields terminated by "," optionally enclosed by '"'
- (ID, LOCATORDESIGNATOR, LOCATORNAME, LOCATOR, THOROUGHFARE, ADDRESSAREA)
- sqlldr scott/tiger@MYDB CONTROL='Ad.ctl' LOG='Ad.log'
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement