Brijesh,
The actual error number(s) would be more helpful ;)
There are issues with exp/imp between single-byte and
multi-byte character sets.
Did you do a conventional or direct-path export?
What are the OS's for the export and import db's?
Have you tried explicitly setting env variable
NLS_LANG to <language_territory>.UTF8 prior to
importing?
HTH,
- Anita
--- "David A. Barbour" <dbarbour_at_nucentrix.net> wrote:
>
>
> Brijesh Lal wrote:
> >
> > Hi
> >
> > The oracle version I am using is 8.15 and I am
> > exporting the data into 8.1.6. When I try to
> import
> > the data I get error that cannot that data cannot
> be
> > imported as it is exported from database with
> USASCII7
> > and being impored into UTF8 format.
> >
> > Brijesh
> > --- "David A. Barbour" <dbarbour_at_nucentrix.net>
> wrote:
> > > 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).
> >
> > __________________________________________________
> > 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: 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).
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: A. Bardeen
INET: abardeen1_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).
Received on Tue Jul 10 2001 - 03:17:08 CDT
