SQL*Loader-00471: OID or SID clause has an argument that is
CONSTANT



SQL*Loader-00471: OID or SID clause has an argument that is CONSTANT..

Answer / guest

Cause: You specified a CONSTANT as an argument in an OID
clause for an object table or in the SID clause for a nested
table column. Since these columns must have unique values,
SQL Loader does not allow the a constant to be specified for
their values.

Action: Store the OID for each row in a filler field and
specify the name of the filler field as an argument.

Please add more information about this Error

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Oracle Errors Interview Questions

RMAN-06459: BACKUP <VALIDATE|DURATION> is not supported with PROXY

1 Answers  


ORA-39070: Unable to open the log file.

1 Answers   IBM,


ORA-13032: Invalid NULL SDO_GEOMETRY object

1 Answers  


ORA-16526: unable to allocate task element

1 Answers  


ORA-24363: measurements in characters illegal here

1 Answers  






RMAN-06555: datafile string must be restored from backup created before string

1 Answers  


LSX-00214: too many occurrences of particle "~1S", maximum is ~2d

1 Answers  


ORA-32124: Illegal attribute passed

1 Answers  


RMAN-06147: no obsolete backups found

1 Answers  


ORA-08111: a partitioned index may not be coalesced as a whole

1 Answers  


ORA-07477: scgcmn: lock manager not initialized.

1 Answers  


ORA-13117: [string]_RELATION$ table does not exist

1 Answers  


Categories