my .ctl file is : LOAD DATA INFILE \"C:\\Users\\nkb1\\Desktop\\fnam开发者_运维技巧es.txt\" INTO TABLE MDB.TEACHERS
I have a Perl script which invokes the sqlldr and loads data to a table from a flat file. Now, my problem is, even though the sqlldr loads the table fine it is returning exit code as -1(got by using
i have a source file i want to load through sqlload in my Oracle 10g 开发者_开发百科the problem is one of the source field can be larger than 4000 character. Is it possible to tell oracle to split a
I\'m currently doing an academic benchmark, TPC-H, and I have some big tables that I want to load using direct path (which workde great and was very fast) and conventional path.
I want to run a sqlldr command customized with some parameters, more precisely a name and a associated number. For now I only have an iteration through names but I want to associate each of it with a
I have multiple when clauses in my control file, the data that i am loading in half of them satisfies the when clauses and gets inserted into the desired table. The other half arent (which i expect) b
Consider that the SQLLoader reads the Input data File from the path and it loads the data into the tables based up on the descrition specified in the control File.
Some of the columns that I am trying to load into Oracle via SQL Loader from an XML file are null. For examplemay have several filled but ocassi开发者_运维百科onally it has some nulls.
I am trying to upload data to a table using sql ldr- sqlldr userid=aa2012/uaxiqdz@ADB control=simple.ctl
I am trying to populate a table with the values taken from a flat file using SQLLDR.The problem is that one of the fields in the table is of CLOB datatype(lets say the field name is COMMENTS). In the
加载中,请稍侯......