Re: moving objects between tablespaces
- From: Maxim Demenko <mdemenko@xxxxxxxxx>
- To: don@xxxxxxxxx
- Date: Fri, 23 Mar 2007 00:39:46 +0100
Don Seiler schrieb:
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.
Dependent plsql objects (including triggers and procedures) become not
invalidated after alter table move.
Best regards
Maxim
--
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
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.
- moving objects between tablespaces
- From: Godwin vincent
- Re: moving objects between tablespaces
- From: Don Seiler