Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- [oracle@stormking db12201 table]$ sqlplus u/u
- SQL*Plus: Release 12.2.0.1.0 Production on Mon Jan 8 22:49:47 2018
- Copyright (c) 1982, 2016, Oracle. All rights reserved.
- Last Successful login time: Sun Jan 07 2018 15:50:08 -05:00
- Connected to:
- Oracle Database 12c Enterprise Edition Release 12.2.0.1.0 - 64bit Production
- SQL> create table xpr ( a number, b varchar2(8) );
- Table created.
- SQL> Disconnected from Oracle Database 12c Enterprise Edition Release 12.2.0.1.0 - 64bit Production
- [oracle@stormking db12201 table]$ cat > xpr.dat
- 1 AAA
- 2 BBB
- [oracle@stormking db12201 table]$ sqlldr u/u table=xpr terminated_by="x'9'"
- SQL*Loader: Release 12.2.0.1.0 - Production on Mon Jan 8 22:52:36 2018
- Copyright (c) 1982, 2017, Oracle and/or its affiliates. All rights reserved.
- Express Mode Load, Table: XPR
- Path used: External Table, DEGREE_OF_PARALLELISM=AUTO
- Table XPR:
- 2 Rows successfully loaded.
- Check the log files:
- xpr.log
- xpr_%p.log_xt
- for more information about the load.
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement