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:
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:
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).