Hi:
I have exp. the data from one database the object has 10 raws, now I am trying to import
the object to other database which already exist with two raws and my import is failing.
Do I need to drop the object before I imp?
Let me know.
Thanks.
Printable View
Hi:
I have exp. the data from one database the object has 10 raws, now I am trying to import
the object to other database which already exist with two raws and my import is failing.
Do I need to drop the object before I imp?
Let me know.
Thanks.
No, you can truncate the table, and then
do import with ignore=y option
if you do not want to keep orginal 2 rows.
I have used ignore=y but did not work.
I haven't try with truncate.
Thanks.