using imp with multiple users in touser
Hi all,
I am about to migrate an 8170 db to 10Gr2 or above.
DB has 2 main users and several other users who just need grants to use the main users' objects.
So for me the easiest way is to export the whole database (exp ... full=yes).
Create the main users in the new db and import all of their stuff. This works ok.
After that I tried to import all other users. The statement used was:
imp "'sys/pw...'" FROMUSER=sys,sys,sys... TOUSER=user1, user2, user3... according to http://docs.oracle.com/cd/E11882_01/server.112/e22490/original_import.htm#i1019223.
But this only imports objects of the 1st user specified (it is the same when I use () or paramfile).
So is there a way to perform import as described above?
Any help appreciated.
FJH