Re: Splitting of tables on the basis of partnum

Also after it's fragmented, try using the high performance loader to unload. Use named pipes and have multiple unload files being created simultaneously. Much faster that way. ----- Original Message ----- From: "Salman Qayyum" <salman404@gmail.com> Sent: Wed, March 25, 2009 5:44 Subject:Splitting of tables on the basis of partnum Hi all, We are in the process of migrating of our informix database to oracle database in SAP environment. We are using SAP specific tools (R3load) to do the migration. Here, while exporting the informix database its taking a very long time. Hence, we are planning to split the large tables into a number of smaller tables. For Example: There is a table objk which is around 350 GB and it is taking about 20 Hrs to export. Here, if we can split this table into 8 smaller tables, the export would finish in say 3 Hrs. If anybody can suggest how we can split this table on the basis of partnum. Something like " update systables set partnum = xxxxx where tabid =XXX and partnum = xxx it would be really helpful. Thank You, Salman _______________________________________________ Informix-list mailing list Informix-list@iiug.org http://www.iiug.org/mailman/listinfo/informix-list ----- End of original message -----