Database Utilities (MOSC)

MOSC Banner

SQL*Loader Errors with SQL*Loader-280 when Inserting Into Global Temporary Table Used as Bit Bucket

edited Nov 4, 2014 11:00AM in Database Utilities (MOSC) 4 commentsAnswered

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.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center