OraFAQ Forum: Server Utilities » import/export issue

Home » RDBMS Server » Server Utilities » import/export issue

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

import/export issue [message #71185]

Sat, 21 September 2002 18:51

yangqi
Messages: 11
Registered: September 2002

Junior Member

Hi:

I'm yangqi from China. I'm a freshman of Oracle DBA. I have some questions
about imp/exp.
I have created a db with the name inst in Oracle 8i, and userid/passwd
inst/inst. And it is necessary to import all data of inst to another db in
Oracle 9i, which has a different db name. I exported the db of inst, but it
failed to import to another db. The error message lists below:

D:SSZUTCInsight2ActuateDatabase>imp iardev/iardev@o02cds0
file=expdat.dmp fro
muser=inst

Import: Release 8.1.6.0.0 - Production on Fri Sep 20 10:57:56 2002

(c) Copyright 1999 Oracle Corporation. All rights reserved.

Connected to: Oracle9i Enterprise Edition Release 9.2.0.1.0 - Production
With the Partitioning, OLAP and Oracle Data Mining options
JServer Release 9.2.0.1.0 - Production

Export file created by EXPORT:V08.01.07 via conventional path

Warning: the objects were exported by INST, not by you

import done in WE8ISO8859P1 character set and UTF8 NCHAR character set
import server uses US7ASCII character set (possible charset conversion)
IMP-00069: Could not convert to environment national character set's handle
IMP-00000: Import terminated unsuccessfully

Can you help me? Thank you in advance!
Regards!
yangqi

Report message to a moderator

Re: import/export issue [message #71191 is a reply to message #71185]

Sun, 22 September 2002 22:41

Saravana Kumar
Messages: 7
Registered: May 2002

Junior Member

u r trying to import using 8.1.6 version whereas ur export was done by 8.1.7 version. upward compatiblity is not there directly. please see the FAQ of Export/Import in ORAFAQ site which has some details on that. I am also in the same boat with u, trying to import oracle 9i data to oracle 8i data.

Report message to a moderator

Re: import/export issue [message #71245 is a reply to message #71185]

Mon, 30 September 2002 18:08

suport
Messages: 2
Registered: September 2002

Junior Member

You may want to try SQLPorter.

It does support all data types during conversion.

http://www.realsoftstudio.com

Report message to a moderator

Previous Topic:	Import database from Oracle to SQL? Help!
Next Topic:	Oracle installation on windows 2000

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sun Mar 16 08:26:24 CDT 2025