Originally posted by paddy04
Hi All,
I think if you specify ignore = Y..it will just see if that object has been imprted or not..if it has been then it will go for the next object...If a table is partly imported then in that case the object.. the table structure is imported but not its all contents in such a case it will ignore the remaining rows... in such a case you will have to continue the import.. and for this particular table selectively import the remaining rows..

Pls correct me if I am wrong..

Hope this helps,

Paddy
If ignore=y is specified , imp tries to create the object and if existing..will ignore it.
If there has been a part import and if the table has constraints in place, all duplicate rows also will be rejected and rest will be inserted. If the table has no constraints, all the data will be loaded.