I am having many tablespaces as LMT with Segment Space Management as manual . Want to change this to auto.
As far as i know u can't alter a tablespace for segment-space management=auto for existing tablespace.

One of the option may be
creating new tablespaces and moving the objects to new tablespace.
But i think lot of works needed to do this operation considering the my db is large one and having many tablespaces

any idea ?