Re: Migrating TOOLS tablespace to ASSM

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.
>
> --
> http://www.freelists.org/webpage/oracle-l
>
>
>
>

--
http://www.freelists.org/webpage/oracle-l