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



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

Answer / guest

Cause: 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.

Action: 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.

Please add more information about this Error

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Oracle Errors Interview Questions

RMAN-06466: error parsing configuration string (string)

1 Answers  


ORA-13214: failed to compute supercell for window object

1 Answers  


DRG-11863: Bad, Incomplete, Or Unknown Response

1 Answers  


ORA-08176: consistent read failure; rollback data not available

1 Answers  


DRG-11715: attempt to add a BT relation between 2 KB categories string and string

1 Answers  


DRG-10017: you must be string to do this: string

1 Answers  


ORA-08340: This command not allowed on nCUBE, only one thread is ever used.

1 Answers  


SQL*Loader-00606: Object string in INTO TABLE clause is not a local table

1 Answers  


PLS-00659: constructor method must return SELF AS RESULT

1 Answers  


ORA-12560: TNS:protocol adapter error

1 Answers  


ORA-19211: column 'string', specified as key using DBMS_XMLSTORE.setKeyColumn() , must be of scalar type

1 Answers  


TNS-00557: unsupported wallet retrieval method

1 Answers  


Categories