If you've got the time and the inclination I'd convert them entirely ie unload/reload (or alter ... move/rebuild).
I don't know of any serious issues with dbms_space_admin on any (patched) version of 8.1.7 hth connor --- Sujatha Madan <[EMAIL PROTECTED]> wrote: > Hi, > > I know this topic has been done to death, but I've > only just migrated to > 8.1.7 from 8.0.6 and am looking into LMT's vs DMT's. > Do listers reccomend > migrating all tablespaces (other than system) or > should I do my temp > tablespace only?? What is the general thought out > there? > > > Also, is the > "dbms_space_admin.tablespace_migrate_to_local()" > package > "reliable" or is there anything that I should be > aware of??? > > Thanks > > Sujatha > > ------------------------------------------- > Sujatha Madan > Database Administrator > Custom Management Centre > Optus Business Operations > 'yes' OPTUS > PH # +61 2 9775 5316 > Mobile # +61 402 354 347 > FAX # +61 2 9775 5360 > Email [EMAIL PROTECTED] > WEB http://www.optusbusiness.com.au/ > ------------------------------------------- > > > -- > Please see the official ORACLE-L FAQ: > http://www.orafaq.com > -- > Author: Sujatha Madan > INET: [EMAIL PROTECTED] > > Fat City Network Services -- (858) 538-5051 FAX: > (858) 538-5051 > San Diego, California -- Public Internet > access / Mailing Lists > -------------------------------------------------------------------- > To REMOVE yourself from this mailing list, send an > E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of > 'ListGuru') and in > the message BODY, include a line containing: UNSUB > ORACLE-L > (or the name of mailing list you want to be removed > from). You may > also send the HELP command for other information > (like subscribing). ===== Connor McDonald http://www.oracledba.co.uk (mirrored at http://www.oradba.freeserve.co.uk) "Some days you're the pigeon, some days you're the statue" __________________________________________________ Do You Yahoo!? Everything you'll ever need on one web page from News and Sport to Email and Music Charts http://uk.my.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: =?iso-8859-1?q?Connor=20McDonald?= INET: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
