Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> RE: SQLLoader

RE: SQLLoader

From: <cosltemp-g.manoj_at_orbitech.co.in>
Date: Fri, 19 Jul 2002 00:58:18 -0800
Message-ID: <F001.0049C584.20020719005818@fatcity.com>


You use the CHARACTERSET keyword to specify to SQL*Loader which character set is used in each datafile. Different datafiles can be specified with different character sets. However, only one character set can be specified for each datafile.

Using the CHARACTERSET keyword causes character data to be automatically converted when it is loaded into the database. Only CHAR, DATE, and numeric EXTERNAL fields are affected. If the CHARACTERSET keyword is not specified, then no conversion occurs.

The CHARACTERSET syntax is:

CHARACTERSET character_set_spec

where character_set_spec is the acronym used by Oracle to refer to your particular encoding scheme.

Note: The characterset specified does not apply to data in the control file

LOAD DATA
CHARACTERSET char_set_name
....

-----Original Message-----
Sent: Friday, July 19, 2002 1:23 PM
To: ORACLE-L
Cc: Antje.Sackwitz

Hi,
I have to load an ASCII dump into Oracle with loader that contains date information in a different national character set than my databse. Can I specify a different nls_lang ( Do an alter session set = nls_lang...)
before the load?
If so, can you please give me the syntax? Regards,
Antje Sackwitz

--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author: Sackwitz, Antje
  INET: Antje.Sackwitz_at_ppi.de

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).

--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author:
  INET: cosltemp-g.manoj_at_orbitech.co.in

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). Received on Fri Jul 19 2002 - 03:58:18 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US