Re: Migrating TOOLS tablespace to ASSM

  • From: Tim Gorman <tim@xxxxxxxxx>
  • To: binhpham15@xxxxxxxxxxx
  • Date: Mon, 11 Jun 2007 20:05:50 -0600

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


Other related posts: