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-15091: operation incompatible with open handle in this session

1 Answers  


ORA-06317: IPA: Local maximum number of users exceeded

1 Answers  


ORA-28527: Heterogeneous Services datatype mapping error

1 Answers  


ORA-10631: SHRINK clause should not be specified for this object

1 Answers  


ORA-07217: sltln: environment variable cannot be evaluated.

1 Answers  






ORA-23395: object "string"."string" of type "string" does not exist or is invalid

1 Answers  


ORA-07212: slcpu: times error, unable to get cpu time.

1 Answers  


PCC-02379: Cannot equivalence National Language character variables

1 Answers  


ORA-19772: change tracking file name exceeds limit of string characters

1 Answers  


ORA-08109: nosort is not a supported option for online index build

1 Answers  


NNL-00558: set|show namesctl_trace_level : set|show the controller's tracing level

1 Answers  


TNS-00092: * CMANAGER (or intlsnr) - will ask the Cmanager only

1 Answers  


Categories