This content has been marked as final. Show 5 replies
By fixed length file do you mean fixed-length records or a fixed-length fields with records separated by new line? By fixed, do you mean fixed number of bytes or fixed number of characters? Have you looked at the file in hex (in an editor with hex display or using the Unix 'od' utility)? What is the code of "ö" in the file?
CREATE TABLE "APP_XXX_XX_XXXX"(
"XXX_XXX_XXXXX" VARCHAR2(1 CHAR),
( TYPE ORACLE_LOADER
DEFAULT DIRECTORY "DIR"
( RECORDS DELIMITED BY NEWLINE
KEY_NO POSITION(1:9) INTEGER EXTERNAL,
XXX_XXX_XXXXX POSITION(10:10) CHAR,
XXX_XXX_XXXXX POSITION(11:19) INTEGER EXTERNAL,
XXX_XXX_XXXXX POSITION(11:14) INTEGER EXTERNAL,
XXX_XXX_XXXXX POSITION(15:16) INTEGER EXTERNAL,
XXX_XXX_XXXXX POSITION(17:19) INTEGER EXTERNAL)
REJECT LIMIT UNLIMITED
The data forms part of a major driver table, which I may not be able to provide as per the NDA with my company.
The Script I have shared is standard template for creating external table as part of our applications.
We majorly cater for EU regions with this project.(European Characterset needed to be supported)
Edited by: RGRAM on Feb 11, 2011 12:44 PM
Please post the exact content of the record from the input file that contains the word "Göteborg" as seen in a hex editor. If there is any sensitive information there, you can first mask it out by replacing certain ASCII letters with 'X' (but do not change the non-ASCII letters, such as "ö").