Hi friends I have a question.

First , I'm going to tell you my problem:

I have squemas in some databases and I want to consolidate the information importing each one to a new schema in a central database.

In this point I have still a problem because each user that I'm importing makes references, grants, etc to the old user names.

Do you know how can I fix the export in order each imported user either grants or references to another user name ?
For instance, I have these schemas in each regional databases:
catalog,
user,
cat_user,
...
etc

Each schema has relations, references, grants, etc to another schemas.

So, I make a full export of each regional database and after that I create the structure in my central database for each user:
catalog1,
user1,
cat_user1,
catalog2,
user2,
cat_user2,
catalog3,
user3,
cat_user3,


Then, I make imports for each regional database:
imp system/manager file=dump_region1.dmp fromuser=catalog
touser=catalog1 full=n ignore=y

But I still having a problem because the file dump_regionN.dmp still making references to old schemas user and cat_user.

Do anybody know how to fix the export in order to reference the new users (user1 and cat_user1)?
That means catalog1 will grant to user1 and cat_user1 instead the old schemas names (user and cat_user).

Thank you for all your answers
Regards