Sure! Use "ALTER TABLE ... MOVE TABLESPACE <another-tablespace>" to move 'em out.
...don't forget to ALTER INDEX ... REBUILD on any indexes associated with a moved table...
Binh Pham wrote:
We are trying to migrate this TOOLS tablespace to ASSM and encountering an issue. There are objects (tables,indexes, materialized views, etc...) owned by SYSTEM that prevents us from changing this TOOLS tablespace to ASSM. Objects that are in the TOOLS for example: SYSTEM.USER_PROFILE SYSTEM.SQLPLUS_PRODUCT_PROFILE Any suggestion? Thanks. -- //www.freelists.org/webpage/oracle-l
-- //www.freelists.org/webpage/oracle-l