Re: Migrating TOOLS tablespace to ASSM

From: Binh Pham <binhpham15_at_hotmail.com>
Date: Wed, 13 Jun 2007 01:23:45 +0000
Message-ID: <BAY103-F2031E7C8FDF5C08E36176AD2180@phx.gbl>

Tim,

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

>From: Tim Gorman <tim_at_evdbt.com>
>Reply-To: tim_at_evdbt.com
>To: binhpham15_at_hotmail.com
>CC: oracle-l_at_freelists.org
>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:
>>
>>SYSTEM.USER_PROFILE
>>SYSTEM.SQLPLUS_PRODUCT_PROFILE
>>
>>
>>Any suggestion? Thanks.
>>
>>--
>>http://www.freelists.org/webpage/oracle-l
>>
>>
>>
>>

---

PC Magazine’s 2007 editors’ choice for best Web mail—award-winning Windows Live Hotmail.
http://imagine-windowslive.com/hotmail/?locale=en-us&ocid=TXT_TAGHM_migration_HM_mini_pcmag_0507

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

Received on Tue Jun 12 2007 - 20:23:45 CDT