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 [EMAIL PROTECTED] 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 [EMAIL PROTECTED]
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: [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).
__
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: [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).
__
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: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists