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: [EMAIL PROTECTED]
>
> 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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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).
