RE: Locally managed ts

http://technet.oracle.com/doc/oracle8i_816/server.816/a76936/dbms_s2a.htm#10 04668 HTH Mark -Original Message- [EMAIL PROTECTED] Sent: 14 March 2002 13:14 To: Multiple recipients of list ORACLE-L Hi all Can we able to change the dictionary managed tablespace to locally managed

Re: Locally managed ts

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

RE: Locally managed ts

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

Re: Locally managed ts

It's version dependent. Convert to local appeared in 8.1.6 or 8.1.7, but was not in 8.1.5. It is probably not a good idea. The tablespace becomes bitmapped managed, but the extent size is the greatest common divisor of the currently existing extents (including free extents) which in the worse

RE: Locally managed ts

Thanks. I was not aware of that. I did not work with 8.1.5. These procedures are available in 8.1.6 and up. - Kirti -Original Message- Sent: Saturday, March 09, 2002 1:43 PM To: Multiple recipients of list ORACLE-L It's version dependent. Convert to local appeared in 8.1.6 or

RE: Locally managed ts

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]