g.mrunalini

 Profile Answers by g.mrunalini 

• Jul 22nd, 2008

 

use the following package

>execute dbms_space_admin.tablespace_convert_to_local('tablespace_name');
>execute dbms_space_admin.tablespace_convert_from_local('tablespace_name');

amit19821

 Profile Answers by amit19821 

• Mar 12th, 2009

 

Local to Dictionary managed tablespcaes:
exec dbms_space_admin.Tablespace_Migrate_FROM_Local('tablespace');

Dictionary to locally managed tablespaces:
exec dbms_space_admin.Tablespace_Migrate_to_Local('tablespace');