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

PCB-00232: Tables not allowed as input bind variables in SELECT statement

1 Answers  


ORA-24270: a row already exists in the string table for these parameters

1 Answers  


ORA-27460: cannot execute disabled job "string.string"

1 Answers  


ORA-32811: subscriber string already exists

1 Answers  


ORA-02463: Duplicate HASH IS option specified

1 Answers  


ORA-26516: no push transaction acknowledgement

1 Answers  


ORA-24005: must use DBMS_AQADM.DROP_QUEUE_TABLE to drop queue tables

1 Answers  


DRG-12408: invalid variable reference: string.string

1 Answers  


PCC-00042: Must EXEC SQL INCLUDE SQLCA when mode=ANSI and WHENEVER SQLWARNING used

1 Answers  


QSM-01123: self-join algorithm could not resolve multiple instances

1 Answers  


ORA-25257: consumer must be specified with a multi-consumer queue

1 Answers  


ORA-39026: master table is inconsistent on validation string

1 Answers  


Categories