Why could not use Bulk Insert?

中级会员 注册时间: 2008-07-05 00:16:56 文章: 37 离线

same title,
my version is 8.5
and why INFA prompt me that the target table or view did not exist when I set the bulk option?
What should I do in order to implement bulk insert?
Thanks

看看是不是这个问题：
http://blog.mydwbi.com/?p=48

中级会员 注册时间: 2008-07-05 00:16:56 文章: 37 离线

my target table do not have prefix name

这篇文章被编辑了 1 次. 最近一次更新是在 2008-08-01 03:19:18

andrew wrote:my target table do not have prefix name

So, what's your source database and target database ? and what's the database version number?

What's the detail error code and error message ?

初级会员 注册时间: 2008-06-18 12:27:30 文章: 14 离线

If the target table has index, it can't use bulk insert. try to drop index then recreate it

论坛CTO 注册时间: 2008-04-23 08:51:09 文章: 58 来自: 不透露 离线

andrew wrote:same title,
my version is 8.5
and why INFA prompt me that the target table or view did not exist when I set the bulk option?
What should I do in order to implement bulk insert?
Thanks

The solution is try to drop any constraint for your table.
if you database is oracle, try to drop any constraint for this table, then you can use bulk load.
if you database is sqlserver and the table has constraints, the job will run successfully, but the bulk load can not take any effect.
It is depend on your database product.

初级会员 注册时间: 2008-08-14 02:51:41 文章: 4 离线

tonyhong86 wrote:If the target table has index, it can't use bulk insert. try to drop index then recreate it

good!

中级会员 注册时间: 2008-07-05 00:16:56 文章: 37 离线

Thanks for all