Re: How to move a table from one tablespace to another

From: Connor McDonald <connor_mcdonald_at_yahoo.com>
Date: Thu, 02 Dec 1999 19:06:18 +0800
Message-ID: <384652AA.4C74@yahoo.com>

Garsen Subramoney wrote:
>
> Hi
>
> I have a table SPT_GRN_LOCS sitting in tablespace SPS3 i need to have it
> moved (with all its index and constraints) to tablespace SPS_LIVE.
>
> Does anyone have a solid idea as to how i can do this.
>
> Thanks

alter table move (8i+)

otherwise:

exp rows=n
get the ddl and change the tablespace
exp rows=y
drop the table
create the table
imp
--

---

Connor McDonald
"These views mine, no-one elses etc etc" connor_mcdonald_at_yahoo.com

"Some days you're the pigeon, and some days you're the statue." Received on Thu Dec 02 1999 - 05:06:18 CST