Danny! Danny Tramnitzke [mailto:[EMAIL PROTECTED]] wrote: > > Ok, sorry for my fractional information. > > the whole Errormessage was "Error during execution > -->SQL error -7050 = Fastload with indexed table not allowed (error > position: 1)" > That's the normal behavior of FASTLOAD. The table to be loaded must not have an index. The reason is that FASTLOAD builds the data pages and sends them to the kernel (no sql insert stuff here). But there is so far no possibility to recreate an index starting at a certain record. The only way is to fully recreate the index. And that's time consuming and in no relation to the amount of data loaded in most of the cases (imagine a table that has 4 GB of data and you add 3 rows with FASTLOAD and recreate the index - uuuh). So to load those indexed tables use DATALOAD. The syntax is pretty much the same - simply replace FASTLOAD with DATALOAD.
Regards, Steffen -- Steffen Schildberg SAP DB Team SAP Labs Berlin _______________________________________________ sapdb.general mailing list [EMAIL PROTECTED] http://listserv.sap.com/mailman/listinfo/sapdb.general
