How to fix the Oracle error SQL*Loader-00470: table string does not have system generated OID?

In this post, you’ll learn more about the Oracle ErrorSQL*Loader-00470: table string does not have system generated OID with the details on why you receive this error and the possible solution to fix it.

Oracle Error Description

SQL*Loader-00470: table string does not have system generated OID

Reason for the Error SQL*Loader-00470: table string does not have system generated OID

You specified an OID clause for a table but the table is either not an object table or the table is an object table but the OIDs for the rows are not system generated.

How to fix the Error SQL*Loader-00470: table string does not have system generated OID ?

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

Verify that the you are loading the correct table. If you are, then you must not specify the OID clause for this table. You should use the OID clause only when the table is an object table, has system generated OIDs and when you want to specify OIDs to be assigned to each row of the table.