Re: Move schema and tablespace

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 Wed Feb 27 2002 - 03:05:28 CET