Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: How to move a user's tables from one tablespace to another tablespace.

Re: How to move a user's tables from one tablespace to another tablespace.

From: Frank Brammer <brammerf_at_bigfoot.com>
Date: 1997/07/08
Message-ID: <01bc8bbd$d85ec2e0$92f6d4d0@franks-notebook>#1/1

Well to do it on-line is nearly impossible, and I say nearly because I believe nothing is truly impossible. What you basically have to do is recreate these tables (and all associated indexes, keys, data and constraints) under a different user with the new tablespace name. I recommend writing a script that makes the move for you; you just pass the script the table name and tablespaces. You will probably what to handle the indexes specially too, it's often better if they are in their own tablespace also. Remember, after moving the table to a different user make sure you drop the old synonym and create a new one. If the table has to be under the original user then just move it back with the correct tablespace name.

Note: Attempting this move while users are accessing the table will be disastrous. Wait until the tables in question are not being utilized. And test, test, test on your DEV or TEST database before trying the script in production.

Good luck,
Frank

Poon Chak Yau <cy_poon_at_ctil.com> wrote in article <33c197d4.948326_at_news.hkstar.com>...
> Hello,
> I want to move a user's tables from SYSTEM table space to
> another table space. Can anyone tell me how to do it without
> affecting operations?
>
> Regards,
>
>
>
  Received on Tue Jul 08 1997 - 00:00:00 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US