The problem is that I got errors of "CREATE TYPE ... already exists"
Why the "ignore=y" does not work in this case?
How to overcome this problem?
Thanks in advance,
If the user defined OBJECT TYPE exists, then imp will report an error even.
The error may look like:
IMP-00061: Warning: Object type "USR1"."POINTTYPE" already exists with a different identifier
"CREATE TYPE "POINTTYPE" TIMESTAMP '2005-12-28:16:42:11' OID '08FF481AE1B5C0"
"30E0435AA83432C030' as object ( x number , y number) ;"
Import terminated successfully with warnings.
It seems to be a bug in 9i.
Workaround is drop object type before imp.