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

ORA-29526: created Java class string"string"

1 Answers  


ORA-22887: type of REF column is not the same as that of its scoped table

1 Answers  


RMAN-08009: channel string: starting archive log backupset

1 Answers  


ORA-16099: internal error ORA-00600 occurred at standby database

1 Answers  


ORA-36634: (XSDUNION02) INTEGER dimension workspace object cannot be used as a concat dimension base.

1 Answers  






ORA-32037: unsupported use of LEVEL in membership condition

1 Answers  


ORA-31221: DBMS_LDAP: PL/SQL - Invalid LDAP SSL wallet passwd.

1 Answers  


ORA-31424: change table has active subscriptions

1 Answers  


ORA-23449: missing user name

1 Answers  


ORA-39127: unexpected error from call to string string

1 Answers  


ORA-24386: statement/server handle is in use when being freed

1 Answers  


DRG-10828: token string is longer than maximum length for column string

1 Answers  


Categories