00070.Oracle迁移数据字典和本地管理的表空间

SQL> select tablespace_name,extent_management from dba_tablespaces where tablespace_name like '%TEST_T%';

 

TABLESPACE_NAME                EXTENT_MANAGEMENT

------------------------------ --------------------

TEST_TEMP                      LOCAL

TEST_TAB                        LOCAL

 

SQL>execute DBMS_SPACE_ADMIN.TABLESPACE_MIGRATE_FROM_LOCAL('TEST_TAB');

BEGIN DBMS_SPACE_ADMIN.TABLESPACE_MIGRATE_FROM_LOCAL('TEST_TAB');