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?
> Rocky
> =====
> Rocky Welch
> Oracle DBA Consultant
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

Best regards,

-Ari Kaplan

Back to Ari Kaplan's Home Page

Home Page