Re: Importing data from dump exported with different character set

Brijesh,

What are the Oracle versions you're exporting from and import into? UTF8 is a superset of US7ASCII, so you shouldn't be having problems. What error are you receiving? If you can't get it to work, can you redo the export? There are several ways to change character sets, which are documented on OTN and Metalink. Most involve changing the NLS_LANG for the session (import or export) but there was an interesting piece on editing the export file to change the reported character set last month on the list. Go to:

http://www.unal-bilisim.com/qa/discus/messages/33/34.html?991400274

for a précis on the procedure, and check out the various Metalink references. If you're going to edit the export file, you MUST use a binary editor.

Brijesh Lal wrote:
>
> Hi All
>
> I have been given the task to export the data from the
> database which has the character set of USASCII7 and
> import it into Databse with UTF8 character. However
> when I try to this the import fails with error. I also
> searched oracle mannual but was unable to find any
> relevant information. Can anyone please tell me how to
> accomplish this task
>
> Thanks and Regards
>
> Brijesh
>
> __________________________________________________
> Do You Yahoo!?
> Get personalized email addresses from Yahoo! Mail
> http://personal.mail.yahoo.com/
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Brijesh Lal
> INET: lal_brijesh_at_yahoo.com
>
> 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: David A. Barbour
  INET: dbarbour_at_nucentrix.net

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).