Database Utilities (MOSC)

MOSC Banner

exp multiple users

edited Aug 16, 2011 2:38AM in Database Utilities (MOSC) 8 commentsAnswered
Hello everyone,

You can export multiple users (over 100) of the same BD and generated so many. Dmp as users?

For example:
exp system / orcl owner = (usu1, usu2, usu3 ..) file = usu1.dmp, file = usu2.dmp ...

Could do it with multiple statements:
exp system / orcl file = usu1 owner = usu1.dmp
exp system / orcl file =
usu2  owner =  usu2.dmp
...
...
But, it could be done in one script?

Thanks!

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center