ora-28668: cannot reference mapping table of an index-organized table
Below I moved a mapping table to a different tablespace.
alter table FONTUS.TRA_TX_MAP move mapping table tablespace USERS;
when I do this then I notice I gain an object in the dba_tables named:
table_name=sys_iot_map_254908
iot_type = iot_mapping
iot_name = tra_tx_map (which is the original table).
So when I compare table counts from before the move to after I now have one extra table. I can't drop the sys_iot_map_254908 table, so I then look into dropping the index that is associated but I am not sure how to build it back and oem does not seem to have the ddl for this index organized table.