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:
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).
Thank you for all your answers
Have you tried using the GRANTS=N and CONSTRAINTS=N options?
Also you can do:
imp system/manager file=dump_region1.dmp show=y
to extract the SQL statements.
Click Here to Expand Forum to Full Width