SQL*Loader-00426: count of elements in VARRAY string comes
after the data for the varray



SQL*Loader-00426: count of elements in VARRAY string comes after the data for the varray..

Answer / guest

Cause: The COUNT clause for a VARRAY field indicates that
the count of elements in the varray is stored in another
data field. However, that data field comes after the varray
data in the data file. Since finding the count field would
require SQL*Loader to know the number of elements in the
VARRAY first, SQL*Loader requires that the count field come
before the VARRAY data.

Action: Move the count field to be before the collection
data in the data file.

Please add more information about this Error

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Oracle Errors Interview Questions

TNS-00266: Navigator: Unknown Request

1 Answers  


ORA-36178: (XSAGGR01) To be used with AGGREGATE, AGGMAP workspace object must be declared with the AGGMAP command.

1 Answers  


ORA-01586: database must be mounted EXCLUSIVE and not open for this operation

1 Answers  


TNS-02022: show rules: Show rules that are currently in effect

1 Answers  


ORA-02095: specified initialization parameter cannot be modified

1 Answers  


ORA-12449: Labels specified for user must be of type USER

1 Answers  


ORA-38201: assert if pin during flush

1 Answers  


ORA-22856: cannot add columns to object tables

2 Answers  


ORA-30479: Summary Advisor error string

1 Answers  


ORA-02761: File number to be canceled is negative.

1 Answers  


RMAN-06503: skipping backupset key string; already backed up on string

1 Answers  


ORA-31004: Length string of the BLOB in XDB$H_INDEX is below the minimum string

1 Answers  


Categories