Date: Tue, 1 Feb 2000 09:17:16 -0600 (CST)
Subject: Re: Moving a user...

On Tue, 1 Feb 2000, Rocky Welch wrote:

> Hi Gang,
> What is the best way to move a user's objects from one tablespace to
> another?
> 
> TIA
> 
> Rocky
> 
> =====
> Rocky Welch
> Oracle DBA Consultant
> rockyw_99@yahoo.com
> 
My favorite way is to use Platinum's TS-Reorg product.

If you don't have it, you can export the table, drop it and recreate it in
the new tablespace with the "CREATE TABLE" command, then import using the
"IGNORE=Y" parameter value.

Be sure that all triggers, constraints, foreign keys, etc. are there. Also
check to see if any packages or procedures that reference the table are
valid (SELECT * FROM ALL_OBJECTS WHERE STATUS = 'INVALID';)

Best regards,

-Ari Kaplan
www.arikaplan.com


Back to Ari Kaplan's Home Page