Batch import TXT files

Method 1. Import text files to ORACLE

Create table hkh_August not dial
(
PHONE_NUM VARCHAR2 (11)
)
ORGANIZATION EXTERNAL
(TYPE ORACLE_LOADER
DEFAULT DIRECTORY TEMP
Access parameters (records delimited by newline fields terminated ',')
LOCATION ('hkh _ 181. TXT ')
);

Method 2 SQL LOADER command Application

1. Create a table structure

Create table HKH_LM
(
ACCT_MONTH VARCHAR2 (8 ),
PHONE_NUM VARCHAR2 (11 ),
PLAN_PRODUCT VARCHAR2 (20)
)

2. Write Control Files
Load data
Infile 'd: \ TEMP \ invalid contact number 9.8. CSV'
Append into table hkh_lm
Fields terminated ","
(ACCT_MONTH, PHONE_NUM, PLAN_PRODUCT)

3. Use the SQLLDR command to import

Error Analysis
ORA-29913: error in executing ODCIEXTTABLEOPEN callout

Solution: create a DIRECTORY object named TEMP in your database and grant the user the read and write permissions.

Author "John Xu"