Advertisement
Guest User

Untitled

a guest
Feb 21st, 2019
73
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.63 KB | None | 0 0
  1. C:Usersleesqlloadertest> sqlldr scott/tiger@MYDB,CONTROL='Ad.ctl'
  2.  
  3. SQL*Loader: Release 10.2.0.3.0 - Production on Tue Sep 11 17:46:43 2012
  4.  
  5. Copyright (c) 1982, 2005, Oracle. All rights reserved.
  6.  
  7. Commit point reached - logical record count 52
  8.  
  9. C:Usersleesqlloadertest> sqlldr scott/tiger@MYDB CONTROL='Ad.ctl' log=ad.log bad=ad.bad
  10.  
  11. LOAD DATA
  12. INFILE 'Masterpiece.csv' BADFILE 'Masterpiece.bad' DISCARDFILE 'Masterpiece.dis'
  13. APPEND
  14. INTO TABLE ADDRESS
  15. fields terminated by "," optionally enclosed by '"'
  16. (ID, LOCATORDESIGNATOR, LOCATORNAME, LOCATOR, THOROUGHFARE, ADDRESSAREA)
  17.  
  18. sqlldr scott/tiger@MYDB CONTROL='Ad.ctl' LOG='Ad.log'
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement