SQL*Loader-00290: PIECED keyword (on column string) allowed
only for lob or long columns



SQL*Loader-00290: PIECED keyword (on column string) allowed only for lob or long columns..

Answer / guest

Cause: The PIECED keyword cannot be used for non lob or long
columns.

Action: Remove the PIECED keyword or use lob or long column
type.

Please add more information about this Error

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Oracle Errors Interview Questions

NNL-00918: Time until server restart: string

1 Answers  


ORA-12980: checkpoint option not allowed with SET UNUSED

1 Answers  


DRG-50930: parser memory failure on line string on column string

1 Answers  


NNO-00104: line string: syntax error, data ignored

1 Answers  


NZE-29194: no CRL found in cache

1 Answers  


NNO-00808: Error connecting to region database

1 Answers  


ORA-06114: NETTCP: SID lookup failure

1 Answers  


ORA-02284: duplicate INCREMENT BY specifications

1 Answers  


AUD-00802: name of index is limited to 22 characters

1 Answers  


NNL-00996: OK responses received: number

1 Answers  


ORA-06448: ssvpstp: Failed with unexpected error number.

1 Answers  


PCC-01005: PROCEDURE DIVISION not found

1 Answers  


Categories