Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Move schema and tablespace
>>2.alter table xxx move tablespace new_tbs;
This won't work with tables containing a LONG column ...
"Violin" <violin.hsiao_at_mail.pouchen.com.tw> wrote in message
news:d22954a4.0202261805.494a3644_at_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 Wed Feb 27 2002 - 12:11:46 CST