SQL*Loader-00294: invalid name % specified in TREAT AS clause



SQL*Loader-00294: invalid name % specified in TREAT AS clause..

Answer / guest

Cause: The type name specified in a TREAT AS clause is
invalid. It might contain characters that are not valid in
the client character set or a quoted string might not be
terminated or the name might be too long to contain a valid
schema name and type name.

Action: Verify that the type name has valid characters and
is not too long. Also, ensure that all quoted strings are
terminated.

Please add more information about this Error

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Oracle Errors Interview Questions

ORA-23379: connection qualifier "string" is too long

1 Answers  


ORA-29539: Java system classes already installed

1 Answers  


LPX-00240: element-start tag is not well formed

1 Answers  


ORA-30738: object "string" does not exist in schema "string"

1 Answers  


ORA-19029: Cannot convert the given XMLType to the required type

1 Answers  






ORA-31654: unable to convert file or volume size as specified to a number

1 Answers  


ORA-19602: cannot backup or copy active file in NOARCHIVELOG mode

1 Answers  


ORA-02475: maximum cluster chain block count of string has been exceeded

1 Answers  


ORA-33454: (ESDREAD07) Discarding compiled code for workspace object because number is now string workspace object, whereas it was string workspace object when the code was compiled.

1 Answers  


ORA-14116: partition bound of partition "string" is too long

1 Answers  


ORA-16720: no available LOG_ARCHIVE_DEST_n parameters to use

1 Answers  


ORA-36155: (XSMXAGGRFROM) workspace object must be a variable or formula of a similar data type to workspace object to be used with FROM, or a TEXT variable or formula to be used with FROMVAR.

1 Answers  


Categories