Mig from DMTS to LMTS

Hello

Our problem is simple and certainly have been already seen
here, we upgrade our 9.2.0.6 databases to 10gr2, we have
some big dictionary managed tablespace with thousands of tables,
wich are heavily fragmented, finding the best practice to migrate them to LMTS with
ASSM, I have found the classical practices : 1) create the new lmts tablespace, move the objects to the new one,

    but with thousand of tables how to proceed, by script ?, is there

    a tool in 10g wich done automaticaly the work ?

2)use DBMS_SPACE, but we know that we can't have ASSM, and
  the fragmentation remain, can we use SHRINK in 10g to eliminate it ?

And one of interest, but I was not able to found confirmation it work :

3) migrate to 10g with keeping the dmts, create a new 10g instance with lmts tbs,

    and use datapump to export objects from the first(dmts) to the new(lmts), and then

    using transportable tablespace, back to original instance...I know that datapump

   allow to select objects of a tbs, but I also read that we can get error ORA-25150 doing that...

Thank you for advices.. Received on Wed Nov 22 2006 - 12:37:23 CST