Environmental Description: Database: Oracle8.1.6oem; System: Windows2000 Server. ******************************************** *********************************************************** ******* Use Notepad to create control file input.ctl, the content is as follows:
Load DataInfile 'Test.txt' - Data File Append Into Table Testfields Terminated BY '|' - Or X'09 'to identify, that is, the field termination and tab Tab (- field name cp_bh char (30) , MC Char (50), CP_LJMC Char (100), ZYH CHAR (20), DJ)
*********************************************************** ************************************************
Text file test.txt content format, such as below
10300108200 | XPB65-113S | Back cover pp 0.34kg | 0030200525 | 3.4200000810300108200 | XPB65-113S | Washing barrel cover light blue transparent ABS | 0030200877 ||
The general situation is exported to each other, and the data exported from Excel can be saved as: Test, ..., and so on. *********************************************************** ************************************************************************ Data Import (SqllDR) using SQL * Loader -? View help)
Execute in "Run", the command is as follows:
SqllDr username / pw control = path / punt.ctl data = path /TEST.TXT log = path BAD = Path
