Skip to Content
0
Former Member
Jan 26, 2012 at 11:33 AM

Table spliting for a table size 500MB

116 Views

Hello all,

I exported several time an oracle database (due to export time optimization for unicode conversion). I splitted several tables with size > 100 GB. But I found one table with size 500MB only taking around 10hours to export. If I split this table I'll be able to save time through parallelisation. The table is ZFI_SDOKCONT1 which is copy SDOKCONT1 used for DMS.

The question is why the export takes so long for this table? (table highly fragmented?).

Is there any way to speed up the export except of unsorted load and table splitting?

Thanks in advance

Best Regards

Muris