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

ORA-22632: AnyDataSet parameter is not valid for the current operation

1 Answers  


ORA-09770: pws_look_up: translation failure.

1 Answers  


ORA-14022: creation of LOCAL partitioned cluster indices is not supported

1 Answers  


ORA-00368: checksum error in redo log block

1 Answers  


LPX-00285: invalid Unicode surrogate ~X ~X

1 Answers  






SQL*Loader-00266: Unable to locate character set handle for string.

1 Answers  


ORA-24417: Session pool size has exceeded the maximum limit

1 Answers  


DRG-10827: open_con must be performed before count_last

1 Answers  


DRG-11834: Unsupported Media Type

1 Answers  


SQL*Loader-00122: Invalid skip_index_maintenance option

1 Answers  


ORA-01521: error in adding data files

1 Answers  


ORA-19583: conversation terminated due to error

1 Answers  


Categories