The LOAD DATA
The CHARACTERSET 'UTF8 - character set set
INFILE 'd: \ buy2 TXT' - to import text data path, can write multiple
The REPLACE into TABLE buy2 - empty additional import the original data and the way to use append into TABLE t_name
Fields terminated by X '09 - to TAB delimited
Trailing nullcols - allows null columns import
(col1, col2)
But I don't know this is going to run in the CMD or in PLSQL Developer, if you have any questions please leave a message
CodePudding user response:
http://m.blog.itpub.net/26770925/viewspace-1379914/CodePudding user response:
1, SQLLDR is operating system commands, perform under CMD2, SQLLDR is import tool, and cannot be derived data,
CodePudding user response:
Sqlloader as import tool, you can export data in the PL/SQL, can also use other tools, I also have a sqlloader import data, the method of hope to help you,My operation:
1. Determine the tables in the database to agree with to insert table fields,
2. Enter the CMD, input: "D:" enter; Input: CD D: \ \ admin \ product \ app 11.2.0 \ dbhome_1 \ BIN (Oracle database installation directory),
3. Edit the control file, and finally with CTL file format,
[SQL] view plain copy
Options (skip=1, rows=128) - skip=1 to skip the first row in the data
- the default is 64 rows, you can specify a more appropriate rows according to the actual parameter to specify each submission record number,
The LOAD DATA
INFILE 'E: \ test \ T_ORDER_DETAIL CSV' - specifies the external data file, you can write multiple INFILE
Specify multiple data files (" another_data_file. CSV ")
-- BADFILE 'E: \ test \ T_ORDER_DETAIL bad' (BADFILE to specify the bad data, can not write)
- DISCARDFILEE: \ test \ T_ORDER_DETAIL dis' (DISCARDFILE specified discarding the data files, you can despise
Append
INTO the TABLE Scott. T_ORDER_DETAIL -- -- target TABLE Scott. ORDER_DETAIL
Fields terminated by ', '- the import data records in a row with ", "separator (X' 09 'tabs segmentation)
Optionally enclosed by '"' - the import data for each field use '"' delimiter
- trailingnullcols table of the field is empty, there is no corresponding value allows optional
(
OID,
PRODUCTID,
CNT,
PRICE
)
4. Edit log files and data files and control files
The control='D: \ test \ T_ORDER_DETAIL CTL'
Data='https://bbs.csdn.net/topics/D:/test/T_ORDER_DETAIL.csv'
The log='D: \ test \ log. The log'
5. The Oracle database files: type "SQLLDR username/password @ former (or IP) control='D: \ test \ T_ORDER_DETAIL CTL data=' D: \ test \ T_ORDER_DETAIL CSV log='D: \ test \ log. The log'
Tested, no problem,
CodePudding user response:
Can use civilian export tool sqluldr2 export data, download address for http://www.onexsoft.com/zh/download use method is simpler, this command helpful instructions, or baidu,