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.
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
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..
I am using python\'s Call method in subprocess module to execute a sqlldr command from subprocess import call
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.
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.
Is it possible to use a fully qualified TNS entry using sqlldr bundled with Oracle 10/11? For example, in SQLPlus:
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.
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.
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