I think he means changing a non ASSM tablespace to an ASSM tablespace which is not possible On 8/22/05, Yasin Baskan <yasbs@xxxxxxxxxxxxxx> wrote: > > > If you are talking about converting dictionary managed tablespaces to > locally managed tablespaces (by saying "from manual to auto") you can do > find out how to do it in pl/sql supplied packages manual. The procedure > is Dbms_space_admin.migrate_to_local. > -- //www.freelists.org/webpage/oracle-l