There are procedures in DBMS_SPACE_ADMIN to do either. And those are: LMT->DMT dbms_space_admin.tablespace_migrate_from_local DMT->LMT dbms_space_admin.tablespace_migrate_to_local
- Kirti -----Original Message----- Sent: Saturday, March 09, 2002 6:13 AM To: Multiple recipients of list ORACLE-L This package(DBMS_SPACE_ADMIN ) does not allow changing dict. managed TS to Locally managed ts. It allows reverse. Bunyamin K. Karadeniz Oracle DBA / Developer Civilian IT Department Havelsan A.S. Eskisehir yolu 7.km Ankara Turkey Phone: +90 312 2873565 / 1217 Mobile : +90 535 3357729 The degree of normality in a database is inversely proportional to that of its DBA. ----- Original Message ----- To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> Sent: Friday, March 08, 2002 3:13 PM > Ayyapps, > > Use the DBMS_SPACE_ADMIN supplied PL/SQL package. > > Jack > -------------------------------- > Jack C. Applewhite > Database Administrator/Developer > OCP Oracle8 DBA > iNetProfit, Inc. > Austin, Texas > www.iNetProfit.com > [EMAIL PROTECTED] > (512)327-9068 > > > -----Original Message----- > [EMAIL PROTECTED] > Sent: Friday, March 08, 2002 4:03 AM > To: Multiple recipients of list ORACLE-L > > > > Hi all > Can we able to change the dictionary managed tablespace to locally managed > tablespace. if so how? > Ayyapps > > -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Deshpande, Kirti 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).
