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

QSM-00787: the tablespace string is invalid for directive string

1 Answers  


ORA-22865: more than one column specified

1 Answers  


ORA-07215: slsget: getrusage error.

1 Answers  


ORA-16562: intended_state not used here, syntax error at "string"

1 Answers  


PCC-02129: CMD-LINE: Client supplied static options table is invalid

1 Answers  






DRG-11508: bad or missing string token on line string

1 Answers  


ORA-14454: attempt to reference temporary table in a referential integrity constraint

1 Answers  


PLS-00612: Number of attributes do not match in SET clause

1 Answers  


ORA-04046: results of compilation are too large to support

1 Answers  


TNS-01169: The listener has not recognized the password

1 Answers  


ORA-13140: invalid target type

1 Answers  


PLS-00241: invalid external type specification for SQLSTATE

1 Answers  


Categories