Tim,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 -0600Sure! 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 anissue. There are objects (tables,indexes, materialized views, etc...) ownedby 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