Skip to Main Content

Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

how to import dmp to 3 different users from another 3 user whith grant info

174772Apr 17 2006 — edited Mar 23 2012
A dmp file from 3 users: user1,user2,user3
exp sys/sys file=c:\dmp.dmp owner=(user1,user2,user3)
and there is grant info among user1,user2,user3.

I want import this dmp to 3 users :userA,userB,userC. include their grant info
imp sys/sys file=c:\dmp.dmp fromuser(user1,user2,user3) touser=(userA,userB,userC)
there are lot of error.

Please ,help me solve thist problem.I want include grant info in 3 new users.

thank you very much.

M.A. zhang
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Apr 20 2012
Added on Apr 17 2006
13 comments
52,993 views