Re: moving objects between tablespaces
- From: "Alexander Fatkulin" <afatkulin@xxxxxxxxx>
- To: godwin.ror@xxxxxxxxx
- Date: Fri, 23 Mar 2007 09:55:10 +1000
Godwin,
you can consider using the dbms_redefinition package. It will make the
move process more "online like". However you still will be faced with
invalidations due to dependency tracking mechanism.
> 2. Can i perform this moving on fly or do i have to restrict anything before
> moving the table?
>
--
Alexander Fatkulin
--
http://www.freelists.org/webpage/oracle-l
- References:
- moving objects between tablespaces
- From: Godwin vincent
- Re: moving objects between tablespaces
- From: Don Seiler
Other related posts:
- » moving objects between tablespaces
- » Re: moving objects between tablespaces
- » Re: moving objects between tablespaces
- » Re: moving objects between tablespaces
- » Re: moving objects between tablespaces
- » Re: moving objects between tablespaces
> 2. Can i perform this moving on fly or do i have to restrict anything before > moving the table? >
- moving objects between tablespaces
- From: Godwin vincent
- Re: moving objects between tablespaces
- From: Don Seiler