RE: Error with Importing

You don't have to upgrade to 8.1.7, just have the person who did the export
from the 8.1.7 instance to use the 8.1.6 EXP tool. Then you can use the
exported dump file to import into your 8.1.6 instance.  What is the
NLS_CHARACTERSET setting of your 8.1.6 database? Is it UTF8? I guess you can
always change it to WE8ISO8859P1 thru server manager and change it back
again after the import. Do it this way in SVRMGR> connect sys as sysdba;
shutdown immediate; startup nomount; alter system enable restricted session;
alter system set job_queue_process = 0; alter database open; alter database
character set WE8ISO8859P1; 
do your import and then change the character set to what it was before, and
disable restricted session. 


-----Original Message-----
From: Mark Anderson [mailto:[email protected]]
Sent: Tuesday, December 17, 2002 8:47 AM
To: Oracle
Subject: [oracle] RE: Error with Importing


I was afraid of that, I guess I go out and get 8.1.7 then.....

Mark

-----Original Message-----
From: David, Romeo B. (Govt) [mailto:[email protected]]
Sent: 16 December 2002 18:37
To: Oracle
Subject: [oracle] RE: Error with Importing


You are right. If your database is 8.1.7 and you are exporting one to load
into a 8.1.6 database, you should use the 8.1.6 EXP tool in the 8.1.7
database instance. I was only commenting on the warning  "objects were
exported by CYBORG, not by you". If one has no IMP_FULL_DATABASE privilege,
importing an export done by another user will not work.



-----Original Message-----
From: Mark Anderson [mailto:[email protected]]
Sent: Monday, December 16, 2002 11:00 AM
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.unsub%%.


---
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].