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

Ignore = Y ???

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

Did you ever read OP thread?

Thanks for all your input, but I have tried datapump.

As the dump file was created using the exp command, and although both databases are 10g, when using datapump, I have to select the option 'Prior to 10g' on "Database Version of Files to Import", otherwise datapump can't read the dump file, and unfortunately this selection doesn't have the 'EXCLUDE' option.

This is pure insanity
Either you import fromuser/touser or you can't do it.