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

Oracle Error Message

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

Reason for the Error

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.

Solution

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.

Share:

Leave A Reply

Your email address will not be published. Required fields are marked *

You May Also Like

Oracle Error Message ORA-24328: illegal attribute value Reason for the Error The attribute value passed in is illegal. Solution Consult...
Oracle Error Message ORA-01346: LogMiner processed redo beyond specified reset log scn Reason for the Error LogMiner has detected a...
Oracle Error Message ORA-13241: specified dimensionality does not match that of the data Reason for the Error An error occurred...