Home » RDBMS Server » Server Utilities » import error
import error [message #165927] Mon, 03 April 2006 06:41 Go to next message
tmp1
Messages: 1
Registered: April 2006
Junior Member
ello! I have two computers
1. oracle 10.2.0.1.0(exp)
2. oracle 10.1.0.2.0(imp)
>imp file=full.dmp full=y ignore=y log=log1.log
Export file created by EXPORT:V10.02.01 via conventional path
import done in CL8MSWIN1251 character set and AL16UTF16 NCHAR character set
IMP-00008: unrecognized statement in the export file:

. importing SYSTEM's objects into SYSTEM
IMP-00017: following statement failed with ORACLE error 990:
"GRANT CREATE EXTERNAL JOB TO "SCHEDULER_ADMIN" WITH ADMIN OPTION"
IMP-00003: ORACLE error 990 encountered
ORA-00990: missing or invalid privilege
.............
IMP-00017: following statement failed with ORACLE error 988:
"CREATE DATABASE LINK "OREX11.KLMN.RU" CONNECT TO "DEPO" IDENTIFIED BY VALUE"
"S '0588B8611E8C1F1458B5E21B8AD1F5EE79' USING 'orex11'"
IMP-00003: ORACLE error 988 encountered
ORA-00988: missing or invalid password(s)
..........

HELP!!!!!!!!!
Re: import error [message #166180 is a reply to message #165927] Wed, 05 April 2006 00:49 Go to previous message
Frank Naude
Messages: 4580
Registered: April 1998
Senior Member
Exp/imp is upwards compatible, but not downwards compatible.

The best solution would be to upgrade your 10.1 DB to 10.2.

You can also try to export the 10.2 DB with 10.1's export utility.
Previous Topic: sqlldr direct path failure in 10g.
Next Topic: Error While Import
Goto Forum:
  


Current Time: Fri Jul 05 18:59:51 CDT 2024