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-29884: domain index is defined on the column to be dropped

1 Answers  


DRG-11803: OK

1 Answers  


EXP-00037: Export views not compatible with database version

1 Answers  


ORA-06309: IPA: No message queue available

1 Answers  


ORA-33922: (MAKEDCL35) You cannot define a surrogate of dimension workspace object because it is a time dimension.

1 Answers  






TNS-00268: ON

1 Answers  


ORA-30456: 'string.string' cannot be refreshed because of insufficient privilege

1 Answers  


LFI-00133: Trying to create file string that already exists.

1 Answers  


RMAN-03012: fatal error during compilation of command

1 Answers  


ORA-33304: (DBVALID02) Note: Record number was allocated but not used. This can result in wasted space.

1 Answers  


ORA-13159: Oracle table string already exists

1 Answers  


PROC-00004: The cluster registry key to be operated on does not exist.

1 Answers  


Categories