Database Utilities (MOSC)

MOSC Banner

SQL*Loader - table with Greek column names - from csv file containing Greek characters - Windows 20

edited Feb 6, 2011 10:18PM in Database Utilities (MOSC) 3 commentsAnswered
I have been trying without success to load a csv file into a table with Greek column names.  The csv file contains Greek characters and is encoded in UTF-8 without BOM. 

I am including my load.cmd and load.ctl below.  Depending on the NLS_LANG I have chosen, I have received different errors, they are the rem entries at the top of Load.cmd.

The server is Windows 2003.  I have set the locale to Greek by "Regional and Language Options" under both tabs "Regional Options" & "Advanced" and have rebooted the server.

Please help. 

Thanks.

Load.cmd

========

rem SET NLS_LANG=GREEK_GREECE.EL8ISO8859P7

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

Instructions for posting

×

1. Select a discussion category from the picklist.


2. Enter a title that clearly identifies the subject of your question.


3. In the body, insert detailed information, including Oracle product and version.


Please abide by the Oracle Community guidelines and refrain from posting any customer or personally identifiable information (PI/CI).


Cloud / Fusion customers - Our Cloud community has moved! Please go to Cloud Customer Connect .


New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center