Re: Move schema and tablespace

From: Violin <violin.hsiao_at_mail.pouchen.com.tw>
Date: 26 Feb 2002 18:05:28 -0800
Message-ID: <d22954a4.0202261805.494a3644@posting.google.com>

Hi,

if you were running on 8i,

1.exp and imp
2.alter table xxx move tablespace new_tbs;
3.alter index xxx rebuild tablespace new_tbs;

Violin.

"Philip Morrow" <cracker_at_mymorrow.com> wrote in message news:<i5Pe8.235608$Gb1.37171385_at_typhoon.tampabay.rr.com>...
> Basically the same question as the previous post but now I also need to put
> the tables and indexs in a different schema and tablespace keeping all the
> constraints and relationships intact.
>
> Thanks again
>
> Phil
Received on Tue Feb 26 2002 - 20:05:28 CST