Re: Migrating TOOLS tablespace to ASSM

  • From: "Binh Pham" <binhpham15@xxxxxxxxxxx>
  • To: tim@xxxxxxxxx
  • Date: Wed, 13 Jun 2007 01:23:45 +0000


Thanks, however, the "alter table ... move..." does not work when they have "Long" column types, and hence the question.

From: Tim Gorman <tim@xxxxxxxxx>
Reply-To: tim@xxxxxxxxx
To: binhpham15@xxxxxxxxxxx
CC: oracle-l@xxxxxxxxxxxxx
Subject: Re: Migrating TOOLS tablespace to ASSM
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:


Any suggestion?  Thanks.


PC Magazine?s 2007 editors? choice for best Web mail?award-winning Windows Live Hotmail.


Other related posts: