RE: move USERS tablespace to locally managed

Mark,

Thanks for the reference. But it seems to quibble with detail that may not affect very many people. My conclusion after reading of what was found is to go ahead and use the package. If you experience the error reported, then the site gives an appropriate work-around.

It dopes not, however, express any real reservation for not using the package.

Tom Mercadante
Oracle Certified Professional

-----Original Message-----
Sent: Monday, November 18, 2002 9:09 AM
To: Multiple recipients of list ORACLE-L

Tom,

There are actually reasons not to use the package Oracle supplies to go from DMT to LMT. For the full details, see Connor McDonald's paper on http://www.oaktable.net/ .

-Mark

On Mon, 2002-11-18 at 08:08, Mercadante, Thomas F wrote:
> John,
>
> Why would you *not* want to use the package provided by Oracle?
>
> The answer to your question is to:
>
> 1). create a new USERS tablespace
> 2). issue ALTER TABLE table_name MOVE new_tablespace commands
> 3). issue ALTER INDEX index_name REBUILD commands.
> 4). issue ALTER USER username DEFAULT TABLESPACE new_tablespace;
> 5). drop the old tablespace.
>
> hope this helps.
>
> Tom Mercadante
> Oracle Certified Professional
>
>
> -----Original Message-----
> Sent: Monday, November 18, 2002 7:03 AM
> To: Multiple recipients of list ORACLE-L
>
>
> If I want to move my USERS tablespace to locally managed(without using
> dbms_admin.migrate_to_local), what are the steps I need to take?
>
> John
>
>
> John Dunn
> Sefas Innovation Ltd
> 0117 9154267
> www.sefas.com
>

-- 
--
Mark J. Bobak
Oracle DBA
mark_at_bobak.net
"It is not enough to have a good mind.  The main thing is to use it
well."
 						-- Rene Descartes
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Mark J. Bobak
  INET: mark_at_bobak.net

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Mercadante, Thomas F
  INET: NDATFM_at_labor.state.ny.us

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).