Pload cannot reorder queries having expressions/aggregates and blobs/udts in the same select list   Reorder the select list in the query in the following order: 1. non-blob non-udt columns 2. inrow udts in the case of fixed format 3. other blob/udt columns


The onpload utility requires that the special columns (simple large column and user-defined types) appear at the end of the select list. The onpload utility will reorder simple SELECT statements but is unable to reorder the select list because of expressions, aggregates, or both.

User response

Reorder select columns manually as explained in error message. Alternatively, you can remove aggregates and expressions from the select list by selecting the columns into a temporary table and then unloading them from that table.

Copyright© 2018 HCL Technologies Limited