OraFAQ Forum: Server Utilities » Problem in Import

Home » RDBMS Server » Server Utilities » Problem in Import

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Problem in Import [message #73860]

Mon, 26 July 2004 23:55

Devnarayan
Messages: 7
Registered: June 2004

Junior Member

I have taken a userwise export of my Oracle 8i(8.1.7) database. I want to import it in Oracle Personal edition 8 database. But whenever i try to import it, "IMP-00069 Could not convert to environment national character set's handle" error message occurs. Is it not possible to import database from Oracle 8i to Oracle PO 8. Please guide me..

Report message to a moderator

Re: Problem in Import [message #73862 is a reply to message #73860]

Tue, 27 July 2004 03:44

Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

do the export and import using the lower version of exp/imp tools.
so take export using oracle 8 PO and import to 8i using oracle 8po version of import.
if there is still the same issue, you need to set NLS_LANG accordingly.

Report message to a moderator

Re: Problem in Import [message #74645 is a reply to message #73860]

Thu, 27 January 2005 01:22

JOHN THIRAVIARAJ
Messages: 1
Registered: January 2005

Junior Member

Please check the following site:

http://forums.oracle.com/forums/thread.jsp?forum=61&thread=51987&message=51987

Report message to a moderator

Previous Topic:	Archiving Old Data
Next Topic:	migrating 7.1.6 to 10g

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Wed Dec 25 19:31:14 CST 2024