a while back I posted about having thousands and thousands of extents across our database. Its been decided that we are going to export that data, redo the tables and then import that data back in.

However some of the tables contain loads and loads of data and we simply dont have the diskspace available to export it it one go.

The tables are partitioned so I would like to export the data partition by partition and do it this way.

So...... how do I export a partition at a time or many at once..

I asked this before but ill ask again anyway, how do I find out the average row length of an index?