Tabulka
SQL> connect tom/oracle_4U
Connected.
SQL> create table zamestnanci (id integer primary key, jmeno varchar2(10));
Table created.
[oel64:oracle:orcl12c]$ cat zamestnanci.dat
1, Tom
2, Matej
3, Tomik
4, Jaroslava
5, Pepa
6, Katka
Import
[oel64:oracle:orcl12c]$ sqlldr tom/oracle_4U TABLE=zamestnanci
SQL*Loader: Release 12.1.0.1.0 - Production on Mon Feb 24 20:00:52 2014
Copyright (c) 1982, 2013, Oracle and/or its affiliates. All rights reserved.
Express Mode Load, Table: ZAMESTNANCI
Path used: External Table, DEGREE_OF_PARALLELISM=AUTO
SQL*Loader-816: error creating temporary directory object SYS_SQLLDR_XT_TMPDIR_00000 for file zamestnanci.dat
ORA-01031: insufficient privileges
SQL*Loader-579: switching to direct path for the load
SQL*Loader-583: ignoring trim setting with direct path, using value of LDRTRIM
SQL*Loader-584: ignoring DEGREE_OF_PARALLELISM setting with direct path, using value of NONE
Express Mode Load, Table: ZAMESTNANCI
Path used: Direct
Load completed - logical record count 6.
Table ZAMESTNANCI:
6 Rows successfully loaded.
Check the log file:
zamestnanci.log
for more information about the load.
Kontrola
[oel64:oracle:orcl12c]$ sqlplus tom/oracle_4U
SQL*Plus: Release 12.1.0.1.0 Production on Mon Feb 24 20:04:12 2014
Copyright (c) 1982, 2013, Oracle. All rights reserved.
Last Successful login time: Mon Feb 24 2014 20:00:52 +01:00
Connected to:
Oracle Database 12c Enterprise Edition Release 12.1.0.1.0 - 64bit Production
With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options
SQL> select * from zamestnanci;
ID JMENO
---------- ----------
1 Tom
2 Matej
3 Tomik
4 Jaroslava
5 Pepa
6 Katka
6 rows selected.
Log file
[oel64:oracle:orcl12c]$ cat zamestnanci.log
SQL*Loader: Release 12.1.0.1.0 - Production on Mon Feb 24 20:00:52 2014
Copyright (c) 1982, 2013, Oracle and/or its affiliates. All rights reserved.
Express Mode Load, Table: ZAMESTNANCI
Data File: zamestnanci.dat
Bad File: zamestnanci_%p.bad
Discard File: none specified
(Allow all discards)
Number to load: ALL
Number to skip: 0
Errors allowed: 50
Continuation: none specified
Path used: External Table
Table ZAMESTNANCI, loaded from every logical record.
Insert option in effect for this table: APPEND
Column Name Position Len Term Encl Datatype
------------------------------ ---------- ----- ---- ---- ---------------------
ID FIRST * , CHARACTER
JMENO NEXT * , CHARACTER
Generated control file for possible reuse:
OPTIONS(EXTERNAL_TABLE=EXECUTE, TRIM=LRTRIM)
LOAD DATA
INFILE 'zamestnanci'
APPEND
INTO TABLE ZAMESTNANCI
FIELDS TERMINATED BY ","
(
ID,
JMENO
)
End of generated control file for possible reuse.
SQL*Loader-816: error creating temporary directory object SYS_SQLLDR_XT_TMPDIR_00000 for file zamestnanci.dat
ORA-01031: insufficient privileges
------------------------------------------------------------------------
SQL*Loader-579: switching to direct path for the load
SQL*Loader-583: ignoring trim setting with direct path, using value of LDRTRIM
SQL*Loader-584: ignoring DEGREE_OF_PARALLELISM setting with direct path, using value of NONE
------------------------------------------------------------------------
Express Mode Load, Table: ZAMESTNANCI
Data File: zamestnanci.dat
Bad File: zamestnanci.bad
Discard File: none specified
(Allow all discards)
Number to load: ALL
Number to skip: 0
Errors allowed: 50
Continuation: none specified
Path used: Direct
Table ZAMESTNANCI, loaded from every logical record.
Insert option in effect for this table: APPEND
Column Name Position Len Term Encl Datatype
------------------------------ ---------- ----- ---- ---- ---------------------
ID FIRST * , CHARACTER
JMENO NEXT * , CHARACTER
Generated control file for possible reuse:
OPTIONS(DIRECT=TRUE)
LOAD DATA
INFILE 'zamestnanci'
APPEND
INTO TABLE ZAMESTNANCI
FIELDS TERMINATED BY ","
(
ID,
JMENO
)
End of generated control file for possible reuse.
The following index(es) on table ZAMESTNANCI were processed:
index TOM.SYS_C0010194 loaded successfully with 6 keys
Table ZAMESTNANCI:
6 Rows successfully loaded.
0 Rows not loaded due to data errors.
0 Rows not loaded because all WHEN clauses were failed.
0 Rows not loaded because all fields were null.
Bind array size not used in direct path.
Column array rows : 5000
Stream buffer bytes: 256000
Read buffer bytes: 1048576
Total logical records skipped: 0
Total logical records read: 6
Total logical records rejected: 0
Total logical records discarded: 0
Total stream buffers loaded by SQL*Loader main thread: 1
Total stream buffers loaded by SQL*Loader load thread: 0
Run began on Mon Feb 24 20:00:52 2014
Run ended on Mon Feb 24 20:00:55 2014
Elapsed time was: 00:00:03.31
CPU time was: 00:00:00.03
Komentáře
