How do I export the Users? [message #70506] |
Mon, 24 June 2002 13:20 |
Steve
Messages: 190 Registered: September 1999
|
Senior Member |
|
|
I imported a database from one server to another using the IMP80/EXP80 commands. The application seems to work great, but when I try to look at the users, I get an error conveying that the users don't exist. I look into the Oracle Security Manager, and sure enough they don't. How do I export the Users from the old Oracle server and import them into the new one? Can someone help...?!?
|
|
|
Re: How do I export the Users? [message #70517 is a reply to message #70506] |
Tue, 25 June 2002 05:45 |
Bruno
Messages: 12 Registered: May 2002
|
Junior Member |
|
|
Hi !
When you use the option fromuser=USER1 TOUSER=USER2 Oracle don't create USER2 even if it don't exist. You should create this user using 'create user user2 ....', find the correct privilege and grant them to user2.( Query DBA_TAB_PRIVS etc.... )
|
|
|