sqlldr example

Sqlldr is used to quickly bulk import data,The example steps are as follows:1. Determine connection examples for Oracleusername/[email protected]I'm using:system/ World @ LOCALORCLThe SID is an example of a connection, the service naming in Net Manager, as follows:　　2. Create a table with the following statement:CREATE TABLE TT ( ID INTEGER, NAME VARCHAR2

SELECTarray_to_string (Array (2 SelectAttName fromPg_attributewhereAttrelid= 'Table name':: Regclass andAttnum> 03 andattisdropped= 'F' 4),',') asNameInterested to try.3. Download the CSV file4. Edit the *.ctl control file1 LoadData2 CHARACTERSET UTF83InFile "/Home/Oracle/hthhf.csv "4 truncate5 into TableT_yw_hthhf_old6Fields terminated by ","7Optionally enclosed by '"'8 trailing Nullcols9 (TenColumn Name 1integerExternal, OneColumn Name 2timestamp"YYYY-Mm-DD hh24:m

Con column in the table is the combined value of ID and nameDtdate "YYYY-MM-DD" Insert date type data)DescriptionLoad dataTell Sqlldr what to do (in this case, indicate that you want to load the data). Sqlldr can also execute continue_load, that is, continue loading. This option is only available if you continue with a multi-table direct path loadINFILE *: If it is an * number, this will tell

column to be imported as a char type-- // If it is: pub_price filler (Note: This column is ignored when the filler is added here, and this column is not loaded))----------------------------------------------------------------Above -- // and the following content are all comments, which can be removed in actual operations; If all are ready! Open CMD and enter sqlldr parfile = pub_goods.par.You can see the running result, which may fail and fail n time

1. Create a data file:For example, to create a zhaozhenlong.txt file in D:\, the file content is:11,12,1321,22,2331,32,332. Create the control file:For example, to create a zhaozhenlong.ctl file in D:\, the file content is:Load da taInFile ' D:\zhaozhenlong.txt 'Append into table ZhaozhenlongFields terminated by ', '(C1,C2,C3)3. Create a table in the database:CREATE TABLE Zhaozhenlong (c1 varchar), C2 varch

headerSet Linesize 32767--Maximum row displaySelect ' # ' | | col1| | ' #,# ' | | col2| | ' #,# ' | | col3| | ' # '--Set the required column format. In this example, columns are separated by commas, and the column contents are caused by #. From Test_data;Exit --Exit SqlplusSpool off--close the poolPause Note: The above command can be executed directly under DOS. 2. write. bat Batch Then write the bat call above the Outputsql file, as follows: cd/Set

userid=scott/tiger'. One may specify parameters by position beforeBut notAfter parameters specified by keywords. For example,'sqlldr scott/tiger Control=foo logfile=log' isallowed, but'sqlldr scott/tiger control=foo log' is not, even though the position of the parameter'Log' isCorrect. One of the lines is "errors--number of errors to allow (Default 50)"So it's not surprising that there are problems.Fin

column format. In this example, columns are separated by commas, and the column contents are caused by #. From Test_data;Exit --Exit SqlplusSpool off--close the poolPause Note: The above command can be executed directly under DOS. 2. write. bat Batch Then write the bat call above the Outputsql file, as follows: cd/Set nls_lang=. Al32utf8--setting character set UTF8CHCP 65001--Conversion code page UTF8@echo offecho Data outputPause@remSqlplus System/[

Tags: Sqlldr enclosed byOracle Sqlldr Optionally enclosed by (GCH)If you edit the control file,you would rather add theclause "Optionally enclosed by" inensurance.The following example is, and the clause "optionallyenclosed by". as follows, never use the clause ' optionally enclosed by ' in the control file.OPTIONS (Skip=1)LoadDataINFILE "/home/oracle/

Label:Sql*loader is an Oracle data load tool that is typically used to migrate operating system files to an Oracle database. Sql*loader is a large dataThe warehouse selection uses the Load method as it provides the quickest way (direct,parallel). Now, let's put aside its theory and use examples to makeYou get a quick grasp of how sql*loader is used.First, let's meet Sql*loader.Under NT, Sql*loader's command is SQLLDR, which is generally

identify recoverable statementsResumable_timeout -- waiting time of RESUMABLE (in seconds) (7200 by default)Date_cache -- size of the date-converted high-speed cache (calculated by entries) (1000 by default)Please note: the command line parameters can be specified by the location or keyword.. The former example is 'sqlloadScott/tiger foo '; the next example is 'sqlldr