Database Reference
In-Depth Information
SQL*Loader: Release 12.1.0.1.0 - Production on Sun Dec 8 22:18:41 2013
Copyright (c) 1982, 2013, Oracle and/or its affiliates. All rights reserved.
Express Mode Load, Table: COUNTRIES
Path used: External Table, DEGREE_OF_PARALLELISM=AUTO
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: COUNTRIES
Path used: Direct
Load completed - logical record count 7.
Table COUNTRIES:
7 Rows successfully loaded.
Check the log file:
countries.log
for more information about the load.
C:\Temp>
SQL> connect hr/hr@LNE6
Connected.
SQL> select * from countries;
CO COUNTRY_NAME REGION_ID
-- ---------------------------------------- ----------
AR Argentina 2
AU Australia 3
BE Belgium 1
BG Bangladesh 3
BR Brazil 2
CA Canada 2
CH Switzerland 1
CN China 3
DE Germany 1
DK Denmark 1
Search WWH ::
Custom Search