How to fix the Oracle error SQL*Loader-00280: table string is a temporary table?

In this post, you’ll learn more about the Oracle ErrorSQL*Loader-00280: table string is a temporary table with the details on why you receive this error and the possible solution to fix it.

Oracle Error Description

SQL*Loader-00280: table string is a temporary table

Reason for the Error SQL*Loader-00280: table string is a temporary table

The sqlldr utility does not load temporary tables. Note that if sqlldr did allow loading of temporary tables, the data would disappear after the load completed.

How to fix the Error SQL*Loader-00280: table string is a temporary table ?

You can fix this error in Oracle by following the below steps

Load the data into a non-temporary table.