Home » RDBMS Server » Server Utilities » ORACLE ERROR 1435
ORACLE ERROR 1435 [message #166624] Fri, 07 April 2006 05:15 Go to next message
Vinay_kmys
Messages: 2
Registered: April 2006
Location: MYSORE
Junior Member
Hi,

I have been trying to import data from an export file.
source database=testdb1
target database=target
I performed the export using the command:
exp system/manage@testdb1 full=y rows=y file=exp1.dmp log=export.log
The export was successful.

I then performed a full import:
imp system/manager@target full=y file=exp1.dmp log=import.log
But I received the following error while importing:
IMP-00003: ORACLE error 1435 encountered
ORA-01435: user does not exist
Import terminated unsuccessfully
Usually, while performing a full import all the users and objects of the source database shoould be imported automatically. I don't understand why it is saying 'user does not exist'.

Somebody please help. It's very urgent. An early response would be highly appreciated.

Thanks,
VINAY.K
Re: ORACLE ERROR 1435 [message #166919 is a reply to message #166624] Mon, 10 April 2006 05:04 Go to previous message
kmsalih
Messages: 197
Registered: March 2006
Senior Member
Hi,

Select username from dba_users;

Try this on both databases.


Rgds
SALIH KM
Cool
Previous Topic: Difference between Oracle 8 and 9i
Next Topic: Importing Tables with new Definition
Goto Forum:
  


Current Time: Thu Jul 04 19:17:43 CDT 2024