RE: Error with Importing
Mättö Joel <[email protected]>
| Newsgroups | gmane.comp.db.oracle.devel |
|---|---|
| Message-ID | <LYRIS-1796914-804320-2002.12.17-08.46.02--gcdod-oracle#[email protected]> |
Hi Oracle 8i online document says: IMP-00069 Could not convert to environment national character set's handle Cause: This is an internal error. Action: Contact Oracle Customer Support. HTH Joel -----Original Message----- From: Mark Anderson [mailto:[email protected]] Sent: 16. joulukuuta 2002 18:00 To: Oracle Subject: [oracle] RE: Error with Importing David, I have done lots of imports in the past successfully. This is the only time I have had this error! Someone has suggested it maybe a problem with importing from an 8.17 into an 8.16 database and the other area I thought it might be was with the NLS (although I can't seem to change to the UK settings the database export was done with) I also wondered if it might be incompatibilities between windows and AIX. But what I really need is any help on how I can do the import or reasons why it won't work, Mark Anderson 01202 775483 07802 404838 mob Web Development and database design mailto:[email protected] http://www.anderson.uk.com -----Original Message----- From: David, Romeo B. (Govt) [mailto:[email protected]] Sent: 16 December 2002 15:23 To: Oracle Subject: [oracle] RE: Error with Importing To be able to import a file exported by someone else other than you, you must be have the IMP_FULL_DATABASE role granted to you. -----Original Message----- From: Mark Anderson [mailto:[email protected]] Sent: Sunday, December 15, 2002 4:07 AM To: Oracle Subject: [oracle] Error with Importing Hi, I'm getting the following error when I try to import a dump file created in Oracle 8.1.7 on AIX. I am importing into Oracle 8.1.6 on Windows 2k server. I believe I need to change the NLS settings BUT every time I try my oracle instance throws an error! The Error:- "Import: Release 8.1.6.0.0 - Production on Fri Dec 13 12:11:54 2002 (c) Copyright 1999 Oracle Corporation. All rights reserved. Connected to: Oracle8i Enterprise Edition Release 8.1.6.0.0 - Production With the Partitioning option JServer Release 8.1.6.0.0 - Production Export file created by EXPORT:V08.01.07 via conventional path Warning: the objects were exported by CYBORG, not by you import done in WE8ISO8859P1 character set and WE8ISO8859P1 NCHAR character set IMP-00069: Could not convert to environment national character set's handle IMP-00000: Import terminated unsuccessfully" All and any help gratefully received. Mark Anderson 01202 775483 07802 404838 mob Web Development and database design mailto:[email protected] http://www.anderson.uk.com --- Change your mail options at http://p2p.wrox.com/manager.asp or to unsubscribe send a blank email to %%email.unsub%%. --- Change your mail options at http://p2p.wrox.com/manager.asp or to unsubscribe send a blank email to [email protected].