-
When doing FULL import on 10g, how to ignore user SYSMAN?
I am importing a dump file that has been created from 10g exp command, and when I try to import this file using the Enterprise Manager on 10g, it creates numerous error messages relating to unique constraints on SYSMAN schema. How do I ignore or prevent from importing the SYSMAN schema? We have 400+ accounts to import.Thanks.
-
use fromuser and touser
write a script
-
I remember when this place was cool.
-
Thanks for your replies.
There are 400 users, so it would be a very long list of fromuser and touser, and I would have to create each user, privileges etc.
Also, I have tried ignore=y but this still gave the errors.
-
for exporting sysman schema,use exp with parameter {constraints = no } and {ignore=y} ,then import it.Bytheway,ignore=y only prevent you to import an object that is already exist in the target schema.
-
er ignore=y means when it encounters an error the import process will continue and ignore the error
-
it s related with what i said above,.That s ,when it sees the object to be imported is already exist ,it gives the error.So it finished with import terminated successfully or unsuccessfully ,but your import should be fine except the objects that already exist in the schema.
-
when the objects exists it will ignore the error that it exists, for example if you are importing a table and the table exists it will ignore the error that it exists but the data will still be imported, i.e ignore=y does NOT prevent you to import an object that is already exist in the target schema.
-
As you said both db's are on 10g
look at the parameter "EXCLUDE" and "TABLE_EXISTS_ACTION" in import data pump
they might help
People with goals know where they are going
-
Did you ever read OP thread?
Last edited by dbasan; 06-19-2007 at 10:54 AM.
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
|