Skip to Main Content
Forums

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!

question about imp using a list of users in fromuser to user

myluismOct 13 2010 — edited Oct 14 2010
Hi all.

I have this simple question:

will this command work in the expected way:

imp system/passwd file=exp.dmp fromuser=(user_a,user_b,user_c) touser=(user_a,user_b,user_c)



objects from user_a will be imported on user_a schema, objects from user_b will be imported on user_b schema,and so on. I mean, objects will be imported in the order given and fromuser and touser accept a list of values?

Regards, Luis ...!
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Nov 11 2010
Added on Oct 13 2010
#database-key-features, #export-import-sql-loader-external-tables
2 comments
623 views