sql-loader

相关标签：javascript jquery android 多少钱 iPhone

Error in loading a data from the txt file to oracle table using sqlldr

my .ctl file is : LOAD DATA INFILE \"C:\\Users\\nkb1\\Desktop\\fnam开发者_运维技巧es.txt\" INTO TABLE MDB.TEACHERS[详细]

2023-03-02 22:30 分类：问答
"No child processes" error in perl

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[详细]

2023-02-24 00:40 分类：问答
Oracle sqlload : split a source field in several columns?

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[详细]

2023-02-19 06:41 分类：问答
Oracle question: Problem improving conventional path load, direct=false, with number of commits and bindsize/readsize

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.[详细]

2023-02-19 00:56 分类：问答
Need help in a batch script: use 1 or 2 arrays OR parse a file with a tuple name number

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[详细]

2023-02-15 08:29 分类：问答
SQLLDR - problem with WHEN clauses

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[详细]

2023-02-12 01:49 分类：问答
how can i validate the data in the control file?

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.[详细]

2023-02-06 15:04 分类：问答
SQL Loader Issue

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.[详细]

2023-01-29 04:22 分类：问答
SQLLDR Error: Object does not exist while trying to insert data to a database

I am trying to upload data to a table using sql ldr- sqlldr userid=aa2012/uaxiqdz@ADB control=simple.ctl[详细]

2023-01-29 02:24 分类：问答
loading data to a table containing clob datatype, from a flat file

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[详细]

2023-01-20 09:51 分类：问答