OraFAQ Forum: Server Utilities » import using sql loader in russian character

Home » RDBMS Server » Server Utilities » import using sql loader in russian character

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

import using sql loader in russian character [message #376877]

Fri, 19 December 2008 00:42

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

Report message to a moderator

Re: import using sql loader in russian character [message #376881 is a reply to message #376877]

Fri, 19 December 2008 00:47

Frank Naude
Messages: 4587
Registered: April 1998

Senior Member

Have you set NLS_LANG correctly?

PS: Please provide us with a test case. We have nothing to work on.

Report message to a moderator

Re: import using sql loader in russian character [message #377220 is a reply to message #376877]

Sun, 21 December 2008 22:52

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

Report message to a moderator

Previous Topic:	export dump striping
Next Topic:	Export in conventional path

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Mon Dec 23 19:43:19 CST 2024