-
Help!: Export/Import question
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
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|