Home » RDBMS Server » Server Utilities » problem while importing
problem while importing [message #176065] Tue, 06 June 2006 14:07 Go to next message
arunasreekari
Messages: 2
Registered: June 2006
Junior Member
Hi,


I have exported the tables of a user to a dump file,
and when i am trying to import the same file into another user of the same database I am getting an error

IMP-0003: Oracle error 1435 encountered
ORA-01435:User does not exits.

I am importing the file with the user who has dba previlages still i could'nt resolve the problem.

can anyone help..

Report message to a moderator

Re: problem while importing [message #176069 is a reply to message #176065] Tue, 06 June 2006 14:59 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
May be the exported objects have a dependency on some other schema.

Report message to a moderator

Re: problem while importing [message #176071 is a reply to message #176069] Tue, 06 June 2006 15:11 Go to previous messageGo to next message
Littlefoot
Messages: 21823
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Is this "new" user already created?
Did you misspell its username?

Report message to a moderator

Re: problem while importing [message #176074 is a reply to message #176069] Tue, 06 June 2006 16:33 Go to previous messageGo to next message
arunasreekari
Messages: 2
Registered: June 2006
Junior Member
No I tried even exporting with default scott schema and the user to which i want to import to ,is also created.still i am getting the same error.

Report message to a moderator

Re: problem while importing [message #176077 is a reply to message #176065] Tue, 06 June 2006 18:15 Go to previous message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
If you REALLY want this mystery solved, you need to show us ALL your work.

Post back here export command line, parameter file & log file using "code" tags".

Post back here output from command line SQL*Plus session using code tags showing user exists before import.

Post back here import command line, parameter file & log file using code tags.

I'm willing to bet dollars to donuts the root cause is PEBKAC.

Report message to a moderator

Previous Topic: Error while exporting
Next Topic: Is it possible to concatenate data into one column?
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Mon Jan 13 14:38:16 CST 2025
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.