Home » RDBMS Server » Server Utilities » import using sql loader in russian character
import using sql loader in russian character [message #376877] |
Fri, 19 December 2008 00:42 ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
preeti_khurana
Messages: 15 Registered: May 2008 Location: Gurgaon
|
Junior Member |
|
|
Hi Gurus
I am trying to import text file in oracle 10g with russian character but it faling as it is not recognizing demiliter as pipe. It is taking the entire row into one column resulting into the failure.
I understand that there is some seetings we need to do oracle Db and OS level before doing the import.
Kindly help me with this.
Regards
Preeti Khurana
|
|
|
|
Re: import using sql loader in russian character [message #377220 is a reply to message #376877] |
Sun, 21 December 2008 22:52 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) |
preeti_khurana
Messages: 15 Registered: May 2008 Location: Gurgaon
|
Junior Member |
|
|
Hi
Please find the test case below:
Table sql:
CREATE TABLE "IMP_PRODUCT"
( "ACTION_TYPE" CHAR(1 BYTE),
"EXT_PRODUCT_ID" VARCHAR2(30 BYTE),
"SHORT_NAME" VARCHAR2(50 BYTE),
"LONG_NAME" VARCHAR2(255 BYTE),
"L1_NUMBER" VARCHAR2(20 BYTE),
"L1_NAME" VARCHAR2(50 BYTE),
"L2_NUMBER" VARCHAR2(20 BYTE),
"L2_NAME" VARCHAR2(50 BYTE),
"L3_NUMBER" VARCHAR2(20 BYTE),
"L3_NAME" VARCHAR2(50 BYTE),
"L4_NUMBER" VARCHAR2(20 BYTE),
"L4_NAME" VARCHAR2(50 BYTE),
"L5_NUMBER" VARCHAR2(20 BYTE),
"L5_NAME" VARCHAR2(50 BYTE),
"L6_NUMBER" VARCHAR2(20 BYTE),
"L6_NAME" VARCHAR2(50 BYTE),
"L7_NUMBER" VARCHAR2(20 BYTE),
"L7_NAME" VARCHAR2(50 BYTE),
"L8_NUMBER" VARCHAR2(20 BYTE),
"L8_NAME" VARCHAR2(50 BYTE),
"L9_NUMBER" VARCHAR2(20 BYTE),
"L9_NAME" VARCHAR2(50 BYTE),
"L10_NUMBER" VARCHAR2(20 BYTE),
"L10_NAME" VARCHAR2(50 BYTE),
"EXT_BRAND_ID" VARCHAR2(20 BYTE),
"BRAND_NAME" VARCHAR2(50 BYTE),
"EXT_MFG_ID" VARCHAR2(20 BYTE),
"MANUFACTURER_NAME" VARCHAR2(50 BYTE),
"SKU_NUMBER" VARCHAR2(20 BYTE),
"EXT_PRICE_FAMILY_ID" VARCHAR2(20 BYTE),
"EXT_PRODUCT_LINE_ID" VARCHAR2(20 BYTE),
"EXT_DEMAND_GROUP_ID" VARCHAR2(20 BYTE),
"SELL_UNITS" NUMBER(18,5),
"SELL_UOM" VARCHAR2(10 BYTE),
"ISDISCONTINUED" CHAR(1 BYTE),
"DATE_DISCONTINUED" DATE,
"STYLE" VARCHAR2(20 BYTE),
"COLOR" VARCHAR2(5 BYTE),
"ITEM_SIZE" VARCHAR2(5 BYTE),
"ISREGULAR" CHAR(1 BYTE),
"ISMARKDOWN" CHAR(1 BYTE),
"ISADPLANNING" CHAR(1 BYTE),
"ERROR_CODE" VARCHAR2(255 BYTE)
) ;
Control file data:
A|10000001|Сыр плавленный Дружба|АБВГДЕЁЖЗИЙКЛМНОПРСТУФХЦЧШЩЪЫЬЭЮЯ|10|Молочные продукты|1001|Сыры|1000101|сыры плавленные|||||||||||||||1|Карат|1|Карат|||||1|1Pk|0|||||0|0|1
Please let me know whats needs to be done.
Till now i have only set
set NLS_LANG=AMERICAN_AMERICA.RU8PC866
This setting is being done at OS level.
Please suugest if i have to set any thing at DB level.
Also after doing this i am able to load data in the table above but the data gets converted into junk cahracters by upward question marks.
Please help.
Thanks
Preeti Khurana
|
|
|
Goto Forum:
Current Time: Sat Sep 07 20:03:30 CDT 2024
|