I'm trying to import only sequences from dump file using Import Utility.
I ran the following command:
The problem is that I got errors of "CREATE TYPE ... already exists"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
Why the "ignore=y" does not work in this case?
How to overcome this problem?
Thanks in advance,