CTL FILE ********************************************************************** LOAD DATA INFILE 'H:\TESTING\NEW1.TXT' BADFILE 'TESTING_BAD.TXT' DISCARDFILE 'TESTING_DISCARD.TXT' REPLACE INTO TABLE TESTING FIELDS TERMINATED BY '?' TRAILING NULLCOLS ( ACCOUNT_DATE date 'MM/DD/YYYY', ACCOUNT_NUMBER CHAR, ACCOUNT_NUMBER_OLD CHAR, ACCOUNT_NAME CHAR, ACCOUNT_REGISTRATION CHAR , CASH_BALANCE "to_number(:CASH_BALANCE,'99999999999999999.00')", MONEY_ACCOUNTS "to_number(:MONEY_ACCOUNTS,'999999999.00')", PRICED_INVESTMENTS "to_number(:PRICED_INVESTMENTS,'9999999999.00')", MARGIN_BALANCE "to_number(:MARGIN_BALANCE,'9999999999.00')", MARKET_VALUE "to_number(:MARKET_VALUE,'9999999999.00')" ) ********************************************************************** LOG FILE SQL*Loader: Release 19.0.0.0.0 - Production on Fri Oct 21 10:17:22 2022 Version 19.3.0.0.0 Copyright (c) 1982, 2019, Oracle and/or its affiliates. All rights reserved. Control File: insert_TESTING.ctl Data File: H:\TESTING\NEW1.TXT Bad File: TESTING_BAD.TXT Discard File: TESTING_DISCARD.TXT (Allow all discards) Number to load: ALL Number to skip: 0 Errors allowed: 1000 Bind array: 250 rows, maximum of 1048576 bytes Continuation: none specified Path used: Conventional Table TESTING, loaded from every logical record. Insert option in effect for this table: REPLACE TRAILING NULLCOLS option in effect Column Name Position Len Term Encl Datatype ------------------------------ ---------- ----- ---- ---- --------------------- ACCOUNT_DATE FIRST * ? DATE MM/DD/YYYY ACCOUNT_NUMBER NEXT * ? CHARACTER ACCOUNT_NUMBER_OLD NEXT * ? CHARACTER ACCOUNT_NAME NEXT * ? CHARACTER ACCOUNT_REGISTRATION NEXT * ? CHARACTER CASH_BALANCE NEXT * ? CHARACTER SQL string for column : "to_number(:CASH_BALANCE,'99999999999999999.00')" MONEY_ACCOUNTS NEXT * ? CHARACTER SQL string for column : "to_number(:MONEY_ACCOUNTS,'999999999.00')" PRICED_INVESTMENTS NEXT * ? CHARACTER SQL string for column : "to_number(:PRICED_INVESTMENTS,'9999999999.00')" MARGIN_BALANCE NEXT * ? CHARACTER SQL string for column : "to_number(:MARGIN_BALANCE,'9999999999.00')" MARKET_VALUE NEXT * ? CHARACTER SQL string for column : "to_number(:MARKET_VALUE,'9999999999.00')" Table TESTING: 6854 Rows successfully loaded. 0 Rows not loaded due to data errors. 0 Rows not loaded because all WHEN clauses were failed. 0 Rows not loaded because all fields were null. Space allocated for bind array: 645000 bytes(250 rows) Read buffer bytes: 1048576 Total logical records skipped: 0 Total logical records read: 7044 Total logical records rejected: 0 Total logical records discarded: 0 Run began on Fri Oct 21 10:17:22 2022 Run ended on Fri Oct 21 10:17:23 2022 Elapsed time was: 00:00:00.45 CPU time was: 00:00:00.01