I am creating Oracle Control files to use with SQL*Loader to import large text file into Oracle. I'm just wondering if this is the best way to do things? From everything I've read it seems to be. These files can vary from 200K to about 4GB in size. I use BULK INSERT in MS SQL to do the same thing right now.
I am building code to generically build the CTL files for the various tables currently and just thought I would get a second opinion.
As anyone else dumping large amounts of data into an Oracle backend this way?
TIA