I have a SQL Loader Control file, LOAD DATA INFILE 'test.txt' INTO TABLE TEST replace fields terminated "|" optionally enclosed by '"' TRAILING NULLCOLS ( DOCUMENTID INTEGER(10), CUSTID INTE...

I am seeing some significant performance differences between OracleBulkCopy (ODP.NET) and SQL*Loader when the Oracle server is on another machine. I have a very basic table in Oracle with three co...

I have written an SQL script having the below query. The query works fine. update partner set is_seller_buyer=1 where id in (select id from partner where names in ( 'A','B','C','D','E',... -- Arou...

How would I disable and later enable all indexes in a given schema/database in Oracle? Note: This is to make sqlldr run faster.

I'm struggling to get sqlldr to import a csv data file into my table, specifically with the field that is a timestamp. The data in my csv file is in this format: 16-NOV-09 01.57.48.001000 PM I'...

I didn't realize this, but apparently Python's strftime function doesn't support dates before 1900: >>> from datetime import datetime >>> d = datetime(1899, 1, 1) >>> d....