IMP-00003:ORACLE error 1435 encountered.
FranklinFaces.com
FranklinFaces.com - Oracle & SQL Server Database Forums for all IT Professionals
 Home          Members     Calendar     Who's On

Welcome Guest ( Login | Register )
        



IMP-00003:ORACLE error 1435 encountered. Expand / Collapse
Message
Posted 7/28/2009 4:22:03 PM Post #147
 

Supreme BeingSupreme BeingSupreme BeingSupreme BeingSupreme BeingSupreme BeingSupreme BeingSupreme Being
When importing a dump, we get the following error into another machine.

IMP-00003:ORACLE error 1435 encountered.
ORA-01435 user doesn't exist
IMPORT terminated unsuccessfully.

This is somewhat easy solution.    Check to see if your  target database has the user you are trying to import.  If not, you may want to create the user first and then import.   Or you can simply do FROMUSER TOUSER to another user.

Another solution would be to take full export with rows=n and try to get all the schemas imported with full=y and rows=nn this way you got the schemas going.  Then do an import with rows=y .    

Hope this helps,

Thanks,

« Prev Topic | Next Topic »


Reading This Topic Expand / Collapse
Active Users: 1 (1 guest, 0 members, 0 anonymous members)
No members currently viewing this topic.

Permissions Expand / Collapse

All times are GMT -5:00, Time now is 9:52am

Powered By InstantForum.NET v4.1.4 © 2012
Execution: 0.076. 7 queries. Compression Disabled.
Contextual Links