Quote Originally Posted by nir_s
Hi folks,

I'm trying to import only sequences from dump file using Import Utility.
I ran the following command:
Code:
imp system/pwd file=exp.dmp log=/tmp/imp_seq.log from user=USER1 touser=USER2 rows=n grants=n indexes=n constraints=n ignore=y
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,
Nir
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.

Tamil