sql-loader
Oracle error:- LRM-00116: syntax error at 'control' following '='
Oracle DB/Windows XP:- I am running an batch file开发者_StackOverflowthat calls an“.ctl” filewhich in turn calls an “.xls” file, both present in the same folder.[详细]
2023-04-11 20:18 分类:问答Is there a sqlldr api for java
I want to use sqlldr from a java program, but I dont want to invoke it using \"Runtime.exec\". is there such api for sq开发者_Python百科lldr in java.No, there is no native API to call SQL*Loader funct[详细]
2023-04-09 09:24 分类:问答Oracle SQL loader Error while loading really huge log files
I have a python script which loops through log files in a directory and uses oracle sqlloader to load the log files to the oracle database. the script works properly and even the sqlloader..[详细]
2023-04-07 18:41 分类:问答how to redirect python's subprocess.Call methods output to a file and not console?
I am using python\'s Call method in subprocess module to execute a sqlldr command from subprocess import call[详细]
2023-04-06 20:29 分类:问答How can I load data conditionally using sqlldr in oracle
I have a txt file as follows. 1st machine_no,2nd emp_no, 3rd shift_type (1 for entry,3 for exit), 4th work_date, 4th is time.[详细]
2023-04-06 11:27 分类:问答using sqlldr in oracle to import data
I have a txt file as follows. 1st machine_no,2nd emp_no, 3rd shift_type (1 for entry,3 for exit,can also be 4 for entry(multiple entry), 5 for exit(multiple exit), 5th work_date, 6th is time.[详细]
2023-04-05 16:44 分类:问答Is it possible for Oracle sqlldr to accept a TNS entry as an instance qualifier in Oracle 10 and 11?
Is it possible to use a fully qualified TNS entry using sqlldr bundled with Oracle 10/11? For example, in SQLPlus:[详细]
2023-04-04 11:55 分类:问答PHP synchronization
I\'m unsure of the best solution for this but this is what I\'ve done. I\'m using PHP to look into a directory that contains zip files.[详细]
2023-04-04 05:16 分类:问答sqlldr return codes - ex_warn
I want to know if my file is loaded complete in the database. if you check the return codes here you can see that 1 and 3 is a fail.[详细]
2023-03-30 23:27 分类:问答SQL*Loader stuck after loading 4.2 billion records
We are stuck with a problem in sql loader. We are trying to load a data file with around 4.6 billion rows (nearly 340 GB) into 2 oracle tables on the basis of some when condition using Sql Loader. But[详细]
2023-03-28 17:58 分类:问答