Advertisement
ExaGridDba

12c express load tsv to table

Jan 8th, 2018
176
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.02 KB | None | 0 0
  1. [oracle@stormking db12201 table]$ sqlplus u/u
  2.  
  3. SQL*Plus: Release 12.2.0.1.0 Production on Mon Jan 8 22:49:47 2018
  4.  
  5. Copyright (c) 1982, 2016, Oracle. All rights reserved.
  6.  
  7. Last Successful login time: Sun Jan 07 2018 15:50:08 -05:00
  8.  
  9. Connected to:
  10. Oracle Database 12c Enterprise Edition Release 12.2.0.1.0 - 64bit Production
  11.  
  12. SQL> create table xpr ( a number, b varchar2(8) );
  13.  
  14. Table created.
  15.  
  16. SQL> Disconnected from Oracle Database 12c Enterprise Edition Release 12.2.0.1.0 - 64bit Production
  17. [oracle@stormking db12201 table]$ cat > xpr.dat
  18. 1 AAA
  19. 2 BBB
  20.  
  21. [oracle@stormking db12201 table]$ sqlldr u/u table=xpr terminated_by="x'9'"
  22.  
  23. SQL*Loader: Release 12.2.0.1.0 - Production on Mon Jan 8 22:52:36 2018
  24.  
  25. Copyright (c) 1982, 2017, Oracle and/or its affiliates. All rights reserved.
  26.  
  27. Express Mode Load, Table: XPR
  28. Path used: External Table, DEGREE_OF_PARALLELISM=AUTO
  29.  
  30. Table XPR:
  31. 2 Rows successfully loaded.
  32.  
  33. Check the log files:
  34. xpr.log
  35. xpr_%p.log_xt
  36. for more information about the load.
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement