-
Notifications
You must be signed in to change notification settings - Fork 1
/
Copy pathloader.cfg
59 lines (57 loc) · 2.43 KB
/
loader.cfg
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
# Database settings: YOU MUST EDIT this section using your Oracle database configuration
[DATABASE]
# Database config can be specified as TNS, if TNS available it will be used
tns : emrdev
# Database config can also be specified as Host/Port/Service
host : 192.168.0.141
port : 1521
service_name : emrdev
user : SCRIPTS
password : sqlscripts10gxxx
# decimal separator used in database server
decimal_separator : ,
schema_name : SCRIPTS
[CONFIG]
# extensions that identify csv files
csv_extentions : csv txt
# input directory for csv files. MUST BE THE SAME AS output_dir
csv_files_dir : csv
# output directory for program generated files. MUST BE THE SAME AS csv_files_dir
output_dir : csv
# output directory for manual configuration files
saved_dir : custom_config
config_file_extension : conf
control_file_extension : ctl
batch_file_extension : bat
sql_file_extension : sql
# number of lines that the program will parse in order to detect data types
csv_lines_to_parse : 10
# number of integer digits to be added to the max_number detected parsing the first n lines (only for number types)
add_integer_length : 4
# number of decimal digits to be added to the max_number detected parsing the first n lines (only for number types)
add_decimal_length : 0
# increase in varchar column length after the max_number detected parsing the first n lines
add_varchar_length : 4000
# increase in clob column length after the max_number detected parsing the first n lines, will be used in ctl file for buffer length
add_clob_length : 1000
sqlldr_executable : sqlldr
;path_to_sqlldr_executable : D:\oracle\product\10.2.0\client_1\BIN
# this string is appended to sqlldr command line options
sqlldr_options : errors=10000
# optional: command to run after sqlldr finish loading data
run_after_loading :
sqlplus_executable : sqlplus
;path_to_sqlplus_executable : D:\oracle\product\10.2.0\client_1\BIN
# CSV default settings: there are the default values that will be used for building the CSV configuration files
[CSV]
separator : |
# decimal separator used in CSV file
decimal_separator : ,
# you can only combime DD, MM, and YYYY strings with any other character
date_format : MM/DD/YYYY
# yes: appends to existing data in table. no: deletes the table and recreates it with new data
append : no
# yes: first line is not loaded and it's used to create column names. no: first line is loaded (use -m option to customize field names)
first_line_is_header : yes
# CSV with double quotes
double_quotes : yes