| getting import errors - Please help [message #173502] |
Mon, 22 May 2006 14:14  |
pzlj6x
Messages: 107
Registered: May 2005
Location: Louisville
|
Senior Member |
|
|
I have taken schema (multiple schemas) level export from ORACLE 10g (version 10.1) by creating parfile.
parfile test01.par contains the below
USERID=system/xxxxx@test01
BUFFER=114688
FILE=/users/test01.exp
LOG=/users/test01.log
OWNER=(scott, user01, user02, user03)
export is run using : exp parfile=test01.par
import is done to the database TEST02 in ORACLE 10g (10.2 later version)
parfile for import is test02.par which contains
USERID=system/xxxxx@test02
FILE=/users/test01.exp
FULL=Y
BUFFER=33554432
LOG=/users/test02.log
import command : imp parfile=test02.par
I get errors while doing the import. Here are basic errors.
Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - 64bit
Production
With the Partitioning and Data Mining options
Export file created by EXPORT:V10.01.00 via conventional path
import done in US7ASCII character set and AL16UTF16 NCHAR character set
. importing SYSTEM's objects into SYSTEM
. importing SCOTT's objects into SCOTT
IMP-00003: ORACLE error 1435 encountered
ORA-01435: user does not exist
. importing USER01's objects into USER01
IMP-00003: ORACLE error 1435 encountered
ORA-01435: user does not exist
......
......
I don't understand this. If the users don't exist, it should create one and do an import of all objects. I can't figure out as to what's going wrong.
Can anyone help me, please
Thank
Ravi
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
