Method for importing text data in Oracle
l DOS environment loading with SQL * Loader command
l Data transfer tools using other databases
l Oracle Enterprise Manager data loading function
Specific technology implements one, DOS environment loading
1. First, the server-side listening service must have been turned on. Test method: DOS Enter C: /> SQLPlus Username / Password @ServiceName
2, then use Oracle's SQLLDR command to perform data for data 1) Oracle database ends must have built structures for data sheets that need to be imported 2) A data source file below the text file MODEL separated by tab. TXT, 3) Exported to Excel Table 3) Handmade an XXX.CTL control file 4) Command line loading data
As of the following example: The following files are default in C: / under, if not, you need to specify the full path 1. Command control file input.ctl content
Command Load Data 1, Control File Identifier Infile '2 '4, specify separator, field termination in X'09', is a tab (tab) (number, name, size) 5, defining the keyword keywords in the sequence control file in the column corresponding table
l INSERT, for the default mode, the table is empty when the data load is started.
l append, add new records in the table
l Replace, delete old records, replace it into new loaded records
l truncate, the same
Use the SQL * loader command under the DOS window to implement data import C: /> SQLLDR Userid = system / manager @ servicename control = input.ctl
Default log file name: Input.log
The default bad log file is: Input.bad
Second, use other database transfer tools
The following is the SQL Server Import Wizard as Example 1. Set the data source server in the Import Export Wizard in the Data, select the data source in the instance to select SQL Server 2, then specify the Oracle data source to import, you need to configure the attribute information of Oracle. Note that the user information of the login database is the scheme name after the data is imported, that is, the table in the SQL Server after importing is named UserName in Oracle. Table name follows the prompt, you can fully import SQL Server Data tables and views, you can also use query statements to return to the columns or rows you want to select. Third, Data Loading Function in Oracle Enterprise Manager
Log in to Oracle's console interface, you can use the data load tool to use the data load tool to use the data loading tool, which is consistent with DOS, no longer repeat
