Re: moving objects between tablespaces

You will have to rebuild those indexes and probably recompile any depended PL/SQL objects (triggers, procedures, etc). It won't move the indexes and no you don't have to move them if you don't want to.

Because of this, I would suggest NOT doing this during peak hours.

Don.

On 3/22/07, Godwin vincent <godwin.ror_at_gmail.com> wrote:
> Hi all,
> I want to move a table A using tablespace TB1 onto tablespace
> TB2. I can issue " Alter table A move tablespace TB2" to get this thing
> done, but my concern is,
>
> 1. If the table A has any indexes, does this moving affect them in anyway?
> do i have to move them too?
> 2. Can i perform this moving on fly or do i have to restrict anything before
> moving the table?
>
>
> Any information will be of a great help.
>
> Thanks,
> Godwin.

-- 
Don Seiler
http://seilerwerks.blogspot.com
--
http://www.freelists.org/webpage/oracle-l