Re: simple query

From: Matthias Hoys <idmwarpzone_NOSPAM__at_yahoo.com>
Date: Sun, 23 Oct 2005 00:02:12 +0200
Message-ID: <435ab6e5$0$15953$ba620e4c@news.skynet.be>

"priya" <priya.palanivelu_at_gmail.com> wrote in message news:1130016720.960091.98820_at_f14g2000cwb.googlegroups.com...
> How will you swap objects into a different table space for an existing
> database ?
> i know one method is by export user
> is there any other way?
>

ALTER TABLE mytable MOVE TABLESPACE mytablespace

+ rebuild indexes and recalculate stats after the MOVE operation

Matthias Received on Sat Oct 22 2005 - 17:02:12 CDT