Originally posted by stecal
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
Note 235805.1 on MetaLink says this is a bug in 9.2, fixed in 10.0.
You have a different problem here. You are trying to create a dictionary managed tablespace in a database that can only handle LMTs (because the system tablespace is LMT).