Home » RDBMS Server » Server Utilities » imp (oracle10g)
imp [message #345315] Tue, 02 September 2008 23:51 Go to next message
dirish
Messages: 232
Registered: November 2006
Senior Member
Hello,

I did an export in oracle8 and importing in oracle10g

I created the tablespaces identical to that of oracle8.

When i launch the import, i get the message:

ORA-01917: user or role 'LOCTRAIN' does not exist


Why am having this error for this user only but not all users.



Thank you
Re: imp [message #345317 is a reply to message #345315] Tue, 02 September 2008 23:55 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
http://www.orafaq.com/forum/t/88153/0/
Please read & FOLLOW the Posting Guidelines as stated in URL above


>Why am having this error for this user only but not all users.
It depends.
Perhaps because user or role 'LOCTRAIN' does not exist.

We don't know how or what you did before starting the import.
Re: imp [message #345318 is a reply to message #345315] Tue, 02 September 2008 23:56 Go to previous message
Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
>>ORA-01917: user or role 'LOCTRAIN' does not exist
the error is self explanatory.
the mentioned user does not exist. May be the the import is trying to grant
the user a certain privilege.
Just precreate the user or ignore the error
Previous Topic: How to load two data columns into one column in table while loading using sqlloader
Next Topic: Importing CSV file into multiple tables using a script
Goto Forum:
  


Current Time: Tue Dec 24 11:19:17 CST 2024