SQL*Loader Errors with SQL*Loader-280 when Inserting Into Global Temporary Table Used as Bit Bucket
I have a data file loaded via SQL*Loader that includes records that are to be discarded. However, SQL*Loader completes with a warning when any records are discarded. So I thought I would use a global temporary table to act as a bit bucket or /dev/null to handle these record types. However, SQL*Loader completes in an error with a SQL*Loader-208 error code when it finds the global temporary table.
Is there are way to tell SQL*Loader to go ahead and write to the global temporary table? This seems like a perfectly valid use case to me. Other options are to manipulate the data file coming from a COBOL process (this will take weeks) or write the unused data to a non temporary table which would be pointless.