Bulk insert to Oracle

In what format are the 200k records?  Query object?  Excel object?  JSON object?  CFDIRECTORY object (which is really just another query object)?

In Oracle, I believe the best way to insert multiple records, whether 100 records, 200k records, or one million records, is to do something like:

INSERT ALL
<!--- begin iterative looping --->
into TableA (col1, col2, col3, col4) VALUES (val1, val2, val3, val4)
<!--- end iterative looping --->
SELECT * FROM DUAL; <!--- THIS IS VERY IMPORTANT --->

HTH,

^ _ ^

Johnny, you really need to know first where the hangup is, whether in cf or the db. Could be either or both  and the "fix" would depend on the actual problem.

So first, do you have anything monitoring cf and/or oracle? You really need one or both to get your best solution  Anything else would just be people guessing