Note 235805.1 on MetaLink says this is a bug in 9.2, fixed in 10.0.Code:SQL> select tablespace_name, extent_management 2 from dba_tablespaces; TABLESPACE_NAME EXTENT_MAN ------------------------------ ---------- SYSTEM LOCAL UNDOTBS1 LOCAL TEMP LOCAL CWMLITE LOCAL DRSYS LOCAL EXAMPLE LOCAL INDX LOCAL ODM LOCAL TOOLS LOCAL USERS LOCAL XDB LOCAL 11 rows selected. SQL> conn / as sysdba Connected. SQL> execute DBMS_SPACE_ADMIN.TABLESPACE_MIGRATE_FROM_LOCAL('USERS'); BEGIN DBMS_SPACE_ADMIN.TABLESPACE_MIGRATE_FROM_LOCAL('USERS'); END; * ERROR at line 1: ORA-10616: Operation not allowed on this tablespace ORA-06512: at "SYS.DBMS_SPACE_ADMIN", line 0 ORA-06512: at line 1




