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