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

RMAN-08591: WARNING: invalid archivelog deletion policy

1 Answers  


PCC-02448: Cannot specify a UCS2 variable in the NLS_NCHAR option

1 Answers  


ORA-12231: TNS:No connection possible to destination

1 Answers  


ORA-02361: error while attempting to allocate number bytes of memory

1 Answers  


ORA-36342: (SNSYN200) The format of the CLEAR command is: CLEAR [ ALL | STATUS ] [ CHANGES | PRECOMPUTES | NONPRECOMPUTES | CACHE ] FROM var1 [var2, var3...] [USING aggmap]

1 Answers  






RMAN-06022: invalid level specified for image copy: number

1 Answers  


ORA-01242: data file suffered media failure: database in NOARCHIVELOG mode

1 Answers  


QSM-02112: top level query has LEFT OUTER, RIGHT OUTER or FULL OUTER join

1 Answers  


ORA-13239: sdo_dimensionality not specified during n-d R-tree creation

1 Answers  


ORA-08179: concurrency check failed

1 Answers  


ORA-01692: unable to extend lob segment string.string partition string by string in tablespace string

1 Answers  


ORA-00361: cannot remove last log member string for group string

1 Answers  


Categories