| 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
|
|
|
|
| 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.
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
