Oracle9i Enterprise Edition Release 9.2.0.1.0 - Production
PL/SQL Release 9.2.0.1.0 - Production
CORE    9.2.0.1.0       Production
TNS for 32-bit Windows: Version 9.2.0.1.0 - Production
NLSRTL Version 9.2.0.1.0 - Production

SQL> drop tablespace logmnr_ts including contents;
drop tablespace logmnr_ts including contents
*
ERROR at line 1:
ORA-14404: partitioned table contains partitions in a different tablespace


SQL> connect strmadmin/strmadminpw@oraprod
Connected.
SQL> select tablespace_name,table_name from user_tables;

TABLESPACE_NAME                TABLE_NAME
------------------------------ ------------------------------
                               AQ$_STREAMS_QUEUE_TABLE_H
                               AQ$_STREAMS_QUEUE_TABLE_I
                               AQ$_STREAMS_QUEUE_TABLE_NR
LOGMNR_TS                      AQ$_STREAMS_QUEUE_TABLE_S
                               AQ$_STREAMS_QUEUE_TABLE_T
LOGMNR_TS                      STREAMS_QUEUE_TABLE
USERS                          SYS_IOT_OVER_31020

7 rows selected.

SQL> alter table sys_iot_over_31020 move tablespace logmnr_ts;
alter table sys_iot_over_31020 move tablespace logmnr_ts
            *
ERROR at line 1:
ORA-25191: cannot reference overflow table of an index-organized table

SQL>