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..