Re: moving tables from one tablespace to another

From: Jurij Modic <jmodic_at_src.si>
Date: Tue, 17 Aug 1999 22:41:52 GMT
Message-ID: <37b9d108.3474189@news.siol.net>

On Tue, 17 Aug 1999 10:22:51 -0400, Jessie Shu <yshu_at_vt.edu> wrote:

>Hi! All,
>Does anyone have any good suggestion about moving tables from one
>tablespace to another? These tables have data inside. And currently we
>are going to
>1) export those tables
>2) drop them from DB
>3) recreate them in new tablespace
>4) import them with IGNORE=Y
>But I was wondering if there is a better way of doing this. Thanks!

If by any chance you are using Oracle8i (8.1.*) you can use a new option of ALTER TABLE command:

ALTER TABLE <my_table> MOVE <NEW_TABLESPACE>;

This preserve any indexes, views, grants, etc for that table.

HTH,
Jurij Modic <jmodic_at_src.si>
Certified Oracle DBA (7.3 & 8.0 OCP)

---

The above opinions are mine and do not represent any official standpoints of my employer Received on Tue Aug 17 1999 - 17:41:52 CDT